B
bvick
Guest
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!!
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!!