I have a pivot table as the record source for a from. the data is Quarterly from 2011.
I want to add a total of the Qtrs for each year and thought I could do it on the form with an expression in a text box on the form but not working for me.
can the total be added to the record source?
TRANSFORM Sum(dw_ddai_parking_permit_productionmonthly.PermitIssued) AS SumOfPermitIssued
GROUP BY dw_ddai_parking_permit_productionmonthly.YearIssued