zero in query count

A

andrew

Hello all!
I have a query to count how many records meet a certain
specification, which is then routed to a form. (The count
is set to count the number of primary keys.)

How do i get it to return zero if there are no applicable
records?

Thanks!
Andrew
 
K

Ken Snell [MVP]

Perhaps using DCount function instead of the query will work better for you.
 

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

The "count" function 3
Query to count records in a table 2
count wirth zero count query 2
Case of the curious query ; count the codes 2
Count queries -- make zeros show 4
Access Dcount (multiple criteria) 3
Query to count total number of occurences in a range 7
count of records that meet criteria from two fields 1

Top