Return a value of zero for null queries

[adacpt]

Hello,


I have a query that depends on the result of multiple other queries to obtain a total value. My problem is that, occasionally, one of the queries returns a null value if it does not find a match. When that happens, my sum query cannot add a null value and, therefore, returns no value. Is there a way to force a query to return a "0" in the event that it does not find a match, so that my summary query can see a "0" instead of null?

Thanks,
Matt

[June7]

Use Nz function.

Nz([fieldname],0)

[adacpt]

That was it! Thank you.