Calculating in A Report

[TNDaffy]

Help, I've been working on these reports for days now, and have made small amounts of progress, I am a fairly new Access user, and I'm trying to calculate totals in a report for example:

Benton County Day Camp Fees
$35.00
$35.00
Total: $70.00 (I can get it to total now but I need it to give me a total
per county for each grouping, and then a grand total, but it's doing this)
Decatur County $35.00
Total: $105.00 (it keeps adding the a running total instead of just the total for that group, I need it to say $35.00 here)

Someone please helpm, I really need to get this done! Thanks!

 

[jimmythegeek]

* Create a County Header, and footer. (View | Sorting and Grouping) Select the County field, and make sure Group Header and Group Footer in the properties, both say "Yes".
* In the County Header put the county name field.
* In the details you put the amount.
* In the County footer you put an unbound text box with =Sum([Amt]) as the control source (change Amt accordingly).
* In the Report Footer put the same text box as the County footer.
* Format the report the way you want it.

This will give you totals for each county, as well as a grand total at the end. Jim Lunde
compugeeks@hotmail.com
Custom Application Development