Hello,
I have a report that is based on a crosstab query which shows the deliveries of water tanks by year and month. The row headings are year and month, column headings are the different size water tanks and the value is the qty received.
For this new year, I would like the 2022 deliveries as a balance brought forward and not see the monthly breakdown for 2022. I tried starting a new report for 2023 with the following formula but I am getting an #error or #Name? error message.
I have a report that is based on a crosstab query which shows the deliveries of water tanks by year and month. The row headings are year and month, column headings are the different size water tanks and the value is the qty received.
For this new year, I would like the 2022 deliveries as a balance brought forward and not see the monthly breakdown for 2022. I tried starting a new report for 2023 with the following formula but I am getting an #error or #Name? error message.
Code:
=DSum("QtyRcvd", "qryRotoplasticsDelNotes_Crosstab", "System = 'Potable Water Tank - 450-gal'" AND "Year = #2022")