Summing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

STRANGE:
I have a aggregate query with Total:sum(nz([PT])+nz([OT])+nz([ST])) as
column heading, with Expression listed.
The results give me all three figures in one column: Ex.
Pt ot st Total
25 25 25 252525

What do I need to do.
 
There is the fact that NZ in a query will often return a string vice a number
when you are expecting a number. This is especially true, when you don't
specify the default value. Try

Total: Sum(CCur(Nz(PT,0)) + CCur(NZ(OT,0)) + CCur(NZ(ST,0)))
Try:
Total: sum(nz([PT])) + sum(nz([OT])) + sum(nz([ST]))

dar said:
STRANGE:
I have a aggregate query with Total:sum(nz([PT])+nz([OT])+nz([ST])) as
column heading, with Expression listed.
The results give me all three figures in one column: Ex.
Pt ot st Total
25 25 25 252525

What do I need to do.
Click to expand...
Click to expand...
 
Back
Top