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