Calculate hours

  • Thread starter Thread starter donna.wilde
  • Start date Start date
D

donna.wilde

I have a query [time from]-[time to] which gives me a list
of the hours used per person.

I have managed to show all the hours per person but cannot
seem to calculate all the hours for all the people i.e.
grand total.

I have tried =sum[expr2] but this only gives me the total
number of records and not the amount of hours used.
 
You probably need something like

SUM([Time from]-[Time To])

This may or may not work for you. The first step is that within a query Access
doesn't recognize calculated fields in other columns. You must repeat the calculation.

THE above solution is a total guess, since you haven't posted your SQL statement.
 
Back
Top