Need help with a query...

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

Guest

Access 97.

Table lists trailers associates worked on and how long it took each to work
the trailer. There could be as many as 5 people working one trailer. Thus
the table will have up to five records for each trailer. I need to calculate
the total time for the trailer. I've created a query that calculates the
time for each individual, however the trailer is listed 5 times (one for each
person). How do I condense this down to one record for each trailer listing
the total time for all 5 associates?

Thanks in advance....
 
Use the Sum aggregate function:

SELECT [Trailer],SUM([Time]) FROM [your table]
GROUP BY [Trailer];

Be sure to use your own table and field names.

Carl Rapson
 
Back
Top