Re: TOTAL package PER DAY AND PER HOUR
- From: John W. Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 08 Nov 2009 16:05:13 -0700
On Sun, 8 Nov 2009 11:47:31 -0800 (PST), Tia <tia.abdelkarim@xxxxxxxxx> 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]
.
- References:
- TOTAL package PER DAY AND PER HOUR
- From: Tia
- TOTAL package PER DAY AND PER HOUR
- Prev by Date: RE: Create form using query doesn't fill fields
- Next by Date: How can you set tabs between subforms so they will tab to next for
- Previous by thread: TOTAL package PER DAY AND PER HOUR
- Next by thread: How can you set tabs between subforms so they will tab to next for
- Index(es):
Relevant Pages
|
