TOTAL package PER DAY AND PER HOUR

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

On Sun, 8 Nov 2009 11:47:31 -0800 (PST), Tia wrote:

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

John W. Vinson [MVP]