TOTAL package PER DAY AND PER HOUR

T

Tia

Hello,
i have a list a list of employees along with salaries, in the query i
have calculated the total of package using:
nz([Basic Salary])+nz([Overtime])+nz([Transportation])+nz
([Accomodation])+nz([Meal Allowances])+nz([Others])

i want to calculate the total per day" total package /30" and the
total per hour"total package/30/9"

Total per day i have used this exp but its not working: total package/
30
total hour: total per day/9

Please help
 
J

John W. Vinson

Hello,
i have a list a list of employees along with salaries, in the query i
have calculated the total of package using:
nz([Basic Salary])+nz([Overtime])+nz([Transportation])+nz
([Accomodation])+nz([Meal Allowances])+nz([Others])

i want to calculate the total per day" total package /30" and the
total per hour"total package/30/9"

Total per day i have used this exp but its not working: total package/
30
total hour: total per day/9

Please help

Two possibilities: first, if you (unwisely) use blanks in fieldnames you must
enclose the fieldname in [square brackets] when you refer to it; and secondly,
you (usually) can't use a newly calculated fieldname in a further calculation.
You'll need to either recapitulate the entire expression, or save the query
calculating the [total package] and base a second query upon it.
 

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

Top