Don't understand how to get a simple group total

[Brad Wood]

I have a query with this data:

EmpID Hours
1 8
1 4
2 6

When I make a report with grouping on EmpID and put a text box in the
group footer with source of [Hours], I get this:

EmpID Hours
1 8
1 4
total: 4
2 6
total: 10

The results are the same no matter what I set the "Running Sum" property
to ("Over Group", "No", or "Over All"). What in the hell do I have wrong?

 

[Duane Hookom]

Try:
=Sum([Hours])

 

[Brad Wood]

Try:
=Sum([Hours])

Thanks; the documentation indicates that "Over Group" and "Over All"
will work just as they sound like they would...

 

[Duane Hookom]

Over Group and Over All are used for Running Sums which you don't need.

--
Duane Hookom
MS Access MVP

Try:
=Sum([Hours])

Thanks; the documentation indicates that "Over Group" and "Over All" will
work just as they sound like they would...