My brain doesn't seem to want to find the answer to this.

I have a timesheet database. The RPT is grouped by Employee ID and by Date. I have everything set up the way it should be and the way it should look.

However, my Total Hours seems to be giving me a running sum after each date group.

Date Hours Comments
8/4/03 1.30 blah blah
8/4/03 2.00 blah blah
Total 3.30

8/5/03 1.00 blah blah
8/5/03 0.30 blah blah
Total 5.00

For 8/5/03, the Total should be 1.30, not 5.00. Instead of giving me the group total for 8/5/03, it is giving me a running sum. I have the bound textbox set to:

Control Source: =sum([hours])
Format: Fixed
Decimal Places: 2
Running Sum: Over Group

The textbox is located in the Date Group Footer where it should be. I made sure that everywhere in the Tables and Queries that the Hours field format was set to "Fixed and 2". What am I missing? Thanks for anyone who helps.

You need to do one of two things:

1. Change the control source from =Sum([hours]) to [hours]

Or

2. Change the running sum to No


You are Effectively Summing the Running Sum.