Turn Null into 0

[Parvie]

Please help with how can I make records that have Null value to return $0 in a query. Right now it is leaving null records empty and shows value for the ones that have values.

Payment ID Payment Amt Payment Date Payment Descrpti
416 $927.00 10/2002 Headphones
417
418 $499.00 11/2002 PDA

Please help!

 

[Peter D]

Use the "Nz" (NullToZero) function

Ex.:

nz(Myfield)

Hope this helps,

 

[Parvie]

Thanks Peter..

I tried Nz. for some reason when I entered criteria, it only shows the one that have value. The one with Null value are completely eliminated from the query result

 

[Mile-O]

Put it in the field name.

Nz(YourField,0)