Null to Zero

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

How do you convert a Null record in a Query to a Zero.

I tried this and it didn't work.

Nz([Overing Amount],[Overing Amount],0)

Thanks
DS
 
The syntax for the NZ function is...
Nz(variant[, valueifnull])
so...
Nz([Overing Amount],0)
is the correct syntax.
Try that.
hth
Al Camp

DS said:
How do you convert a Null record in a Query to a Zero.

I tried this and it didn't work.

Nz([Overing Amount],[Overing Amount],0)

Thanks
DS
Click to expand...
 
Back
Top