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.
 
can you post what you have so far so that we can see what it is you are
trying to do
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating hours on a timeclock form 7
Query quandary 5
Total Query: Adding a field to a calculation. 3
summing hours in a query 9
Converting an integer to hours in a query 3
Time Calculated minus breaks & lunch 2
Multiple IIF query 1
Help with query calculation 2

Back
Top