Dealing with null values

[carvind]

I have a query that returns values for two fields. In some cases, null values are returned and I would like the query to return the value 0 for both of them instead of a null. Can anyone a suggest a method to accomplish this? Any help would be greatly appreciated.

 

[Rich]

Look up the Nz function.

 

[carvind]

I tried NZ function but it didn't work. I am still getting null values instead of zeros.

 

[Rich]

Nz([somefield],0)?

 

[mstorer]

Yea, Nz([somefield],0)should work.