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.

Look up the Nz function.

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

Nz([somefield],0)?

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