finding totals

  • Thread starter Thread starter evel79
  • Start date Start date
E

evel79

Here is my scenario:

ID Date Tonnage
76 6/1/2002 12:03 3000
34 1/4/2001 08:45 1500
50 8/12/2003 10:19 1200
76 5/31/2002 11:13 3000

I need a query where it would total the tonnage where the ID fields
are equal (in this case ID = 76) AND I want to show the total ONLY
in the Min(Datevalue(Date)).

So if I query for the tonnage for the month of May 2002. The total
would be 6000, not just 3000
 
create a totals query grouping on ID and selecting the FirstOf for th
date, and the SumOf for the Tonnage. Totals can be turned on from th
View menu
 
Back
Top