Lady Gragor
Registered User.
- Local time
- Today, 21:28
- Joined
- Nov 4, 2008
- Messages
- 37
Hi,
Would someone be abe to advise me on this please. I have a query which brings together values of a number of other queries. I then have a field which totals and displays as below.
Criteria 1: Total
Criteria 2: Total
Criteria 3: Total
Criteria 4: Total
My problem is that where a null value is contained within one of the queries, I get an incorrect result. Here is the field expression:-
Total Labour Cost: Sum(Nz([Regular Pay])+Nz([Overtime Pay])+Nz([Allowance & Other Pay])+Nz([Annual Leave])+Nz([LSL])+Nz([Super])+Nz([Payroll Tax])+Nz([Workcover])+Nz([Other]))
Any advice please?
Would someone be abe to advise me on this please. I have a query which brings together values of a number of other queries. I then have a field which totals and displays as below.
Criteria 1: Total
Criteria 2: Total
Criteria 3: Total
Criteria 4: Total
My problem is that where a null value is contained within one of the queries, I get an incorrect result. Here is the field expression:-
Total Labour Cost: Sum(Nz([Regular Pay])+Nz([Overtime Pay])+Nz([Allowance & Other Pay])+Nz([Annual Leave])+Nz([LSL])+Nz([Super])+Nz([Payroll Tax])+Nz([Workcover])+Nz([Other]))
Any advice please?