Calculating in a group

[Indigobuni]

I have created a fairly simple expense report in Access. The info gets filled in on a form. Under the query, all I do is specify the criteria as the person's name, beginning date and ending date.

My report is grouped by name (in case we want to run more than one person at a time). Under the group footer, I have a bound textbox to the "Amount" field in the report. I am trying to get the overall group total for that person, so they can be reimbursed.

When I pull up the report, everything looks fine, except for the "Total Amount." It seems to only report the very first amount. I didn't enter in any formula or anything. I just bound it to the Amount field and tried setting the bound box to OverAll, OverGroup, etc and it still comes up the same.

Example:

8/10/03 Training Fee for training course $165.00
8/11/03 Parking Parking for training 6.50
8/12/03 Misc Copy Card for Manuals 20.00

My bound textbox will only recognize the $165.00 and not total everything up. Can someone help? Thanks.

 

[ColinEssex]

Create a textBox in the group footer and put this in the control source

=Sum([FieldName])

Col

 

[Indigobuni]

Thanks

Thanks ever so much. That worked perfectly.