Grouping Records In A query?

alexi

Registered User.
Local time
Tomorrow, 00:23
Joined
Feb 26, 2003
Messages
65
Gday,

I have a query in which it has information from a table that has been entered from a timesheet.
I have 3 expressions in it, which tell me the cost of hours, chemical and plant.
However, this calculation is done on each line, or each entry from the timesheet. I want to group all the tasks of the same number together and give a total figure for each expression on the query.
so instead of

Task Expr1 Expr2

1.0 20 50
1.0 30 60
1.0 40 70
2.0 20 10
2.0 10 10

it would be

Task Expr1 Expr2

1.0 90 180
2.0 30 20

Any ideas?

Ta
 

Users who are viewing this thread

Back
Top Bottom