Subtotals On Calculated Fields

[bvick]

I have a sticky situation that I need help with. I am creating a report that requires me to compare the same field (fieldname: ASA) from yesterday and the day before. Weekends are not included. I am then showing the difference in an unbound field called ChangeASA. How do I then get the subtotal of the ChangeASA field?

Example:
Date ASA ChangeASA
1/31/00 14 ---
2/1/00 15 1
2/2/00 20 5

I then need to show the total change in the ASA for the month. I don't have a field for the ChangeASA in my database (and I don't want one). It took me a good while to figure out the calculation of day-to-day comparison (via a macro assigned to the On Print property of the Report's Detail Section). Please help!!

 

[dennyryan]

You might be able to do something with VBA code in the OnPrint Event, i.e. maintain your own variable and increment it on every record. Just an idea, not necessarilly a practical one.

Denny