If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
TOTAL package PER DAY AND PER HOUR
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] |
Thread Tools | |
Display Modes | |
|
|