Access2003 Sum a Calculated Control in a Report
Posted on 2004-11-10
This is a continuation of "AC2003 IIF function calculation". The calculated field is located in the detail section of the report and it has the following code: IIF([BidAmount]=0, [BudgetAmount]*[GetPercent], [BidAmount]*[GetPercent]).
What I need to do is total the projected sales for the person, month (everyone), and a grand total. I have footers in the report for the person, month, and the report footer itself for the grand total.
How do I go about getting the sub-totals and grand total to tally from the calculated field in the detail section of the report?