Return Zero if No Records

D

DM - NPS

I have setup a query to look for inappropriate data. I then setup another
query to count the number of records in the first query which are then
reported on a from.

The problem is, if there are no bad records, the first query returns
nothing. So then the 2nd query returns nothing.

What I really need is for the 2nd query to return a value of "0" when there
are no records.

Any ideas?
 
K

KARL DEWEY

If I run a query as you described I get the zero count.
Post the SQL of your second query by opening in design view, click on VIEW -
SQL View, highlight all, copy, and paste in a post.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query criteria - exclude data and return all records if null 3
Return Random Sampling from Query 2
Query to return Parent rows that have no Child records 2
How to filter on calculated dates 3
Null or NOT in another table 4
Query returns no records problem 4
IIF statement in criteria not working 1
Parameter Query No Results - Needs to Auto Create Record 4

Top