Hi:
I created an Access 365 report that displays job-to-date cost information. It is grouped by ProjectName, and it successfully subtotals the sub category records within each project in the ProjectName footer. My ultimate goal in the report header would be to display the average, maximum, and minimum $ values of each group as shown in the picture.
What I've tried so far is to create a text box for each value in the report header. For example, to calculate the average of all the subtotals, I've tried =Avg(Sum([JTDCost])) as the Control Source formula, but I get "Cannot have aggregate function in expression Avg(Sum([JTDCost])))." Is it even possible to do what I'm attempting? Thanks for any insights or other options I should try.