combine same dates in a report

[Lee]

I have a Query with a Date Field, Hours Field, Total Weight field, and Total
Man Hours per Pound Field. I can have the same Date used for more then one
entry. How can I combine the same Dates in a Report that will add the other
fields together?

 

[Al Campagna]

Lee,
Use a View/Totals query.
DateField Hours TotalWgt ManHours
GroupBy Sum Sum Sum

This will show totals for each DateField...
DateField Hours TotalWgt ManHours
1/1/06 10 5 7
1/1/06 12 6 8
1/2/06 4 3 9

would yield...
1/1/06 22 11 15
1/2/06 4 3 9