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