Query based on other queries

[jmar93]

I am using Access 2007 and have a query call "qryProductionR eport" that uses multible other queries as it's records source. When any of these source queries returns a null value then "qryProductionR eport" returns no values at all. Is there a way to work around this or a way to get the source queries to return a value of "0" instead of a null value?

thanks,
Jeff

[ADezii]

I am using Access 2007 and have a query call "qryProductionR eport" that uses multible other queries as it's records source. When any of these source queries returns a null value then "qryProductionR eport" returns no values at all. Is there a way to work around this or a way to get the source queries to return a value of "0" instead of a null value?

thanks,
Jeff

NULLS have a funny way of propagating through Expressions, convert any Field Values that could possibly contain NULLS to something less harmful using the Nz() Function.

[NeoPa]

Jeff, I'm curious as to what you mean when you say that no values at all are returned. Do you mean the records aren't there or simply that no values are shown within it?