By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,081 Members | 1,342 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,081 IT Pros & Developers. It's quick & easy.

Query based on other queries

P: 46
I am using Access 2007 and have a query call "qryProductionReport" that uses multible other queries as it's records source. When any of these source queries returns a null value then "qryProductionReport" 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?

Mar 7 '09 #1
Share this Question
Share on Google+
2 Replies

Expert 5K+
P: 8,692
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.
Mar 7 '09 #2

Expert Mod 15k+
P: 31,761
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?
Apr 4 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.