TOTAL package PER DAY AND PER HOUR

  • Thread starter Thread starter Tia
  • Start date Start date
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
 
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
Click to expand...

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.
 
Back
Top