combine same dates in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top