Return Zero if No Records

  • Thread starter Thread starter DM - NPS
  • Start date Start date
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?
 
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.
 
Back
Top