How does Access declare the variables for the entries in tables?

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

Guest

I am trying to set up a macro that will run a different query if the first
one turns up null. I cant figure out how to declare that the query result is
null so that my if statement will work.
 
Check out the DCount function in Help. It will return a value of zero if
there are no records returned by the query.
 
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

Declaring variables 9
Help the ignorant! Variable Declaration/Scope/lifetime 5
Access Error 3162 - Null Value To A Variable 1
updating a table based on data in same table 2
Multiple Parameter Crosstab query filter by form 1
Declaring Variables 3
Aggregate Function Error 0
How to construct a hierarchy from a list? (Access 2003) 4

Back
Top