Oct 18 2006, 12:11 PM
I have a report based on donations. The amount is listed, and the type of donation is listed. I would like to get the total amounts based on the type of donation. I have a text box currently with =sum(amt) which gives me the totals for everything, but I just cannot think of how to get it for each type of donation...
Thanks in advance
Oct 18 2006, 12:54 PM
Open the report in Design View. Click View--->Sorting and Grouping... Put the field you want to group on in the first row of the box that appears. Set Group Footer to Yes.
Copy the text box that is already giving you the overall total and paste it into the Group Footer. You'll need to locate it AFTER you paste it.
Oct 18 2006, 01:02 PM
Oct 18 2006, 01:12 PM
You're welcome. I am glad I could help.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here