Test for query returning no records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Access 2003. Trying to implement some VBA code (logic) to test if a query
returns zero records. It is not even clear for me how or what I test for.
Obviously if the record count in the query results is zero then my condition
has been found, but I am at a loss as to the "best" If statement to build to
test for this. Is an empty (no records) query result considered a null set,
and will the IsNull function test properly ? Thanks in advance for the great
help always found here.
 
You can simply use DCount() function to check whether the Query returns any
row.

Check Access VB Help on the DCount() function.
 
You must log in or register to reply here.

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

Testing for null 4
query with zero records 6
Make table query: [Enter 1] AS Test 1
Parameter Query No Results - Needs to Auto Create Record 4
Return Zero if No Records 1
Query returns wrong records 4
Query for Export 1
Query returns incorrect results 2

Back
Top