Sum Query

[Guest]

I need to find the sum for a user entered range of records.

I made a form to enter a startdate and enddate, Thanks Fred.

The query is filtering for School Related Overtime and for Paid Overtime vs
CompTime Overtime.

The query Sums the hours of overtime.

When I added the Date field, to filter by a range, the sum line is now
divided by each record that has a different date. This is what I am putting
in the critera line of the date field to filter:
Between [forms]![ParamForm]![StartDate] And [forms]![ParamForm]![EndDate]

Any ideas on how I can get the sum of hours to be all the records between a
set of dates?

 

[John Spencer (MVP)]

If you are using the query grid, change the "Group By" under the date field to
"Where". This will uncheck the Show item (but that is what you need to do).

Hope this helps.

IF you are still stuck, switch your query to SQL view and copy the SQL statement
and post it here. Someone should be able to modify it for you and then you can
paste it back into a copy of your query for testing.