Need help with a query...

[Boz]

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....

 

[Carl Rapson]

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