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

Can I force a query to return a 0 when any portion returns a null?

P: 1
I have a database that tracks production line failures by model number and yearly quarter. The problem is that if any of the models have yet to be produced during any quarter of the year the entire query returns blank. I have tried using the Nz() function but with no success. Any wisdom anyone can impart will be greatly appreciated.
4 Weeks Ago #1
Share this Question
Share on Google+
1 Reply

Expert Mod 2.5K+
P: 3,385

Welcome to Bytes!

It would help to see what you are working with. If you could provide more on your tables, and a sample of the Query you are using, that might help us all get started in the right direction.

Thanks! Hope we can hepp!
4 Weeks Ago #2

Post your reply

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