Null to Zero

[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

 

[AlCamp]

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

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

 

[dsindo]

you have an extra argument dude..should be Nz([overing amount],0)..