Test for no records in macro

  • Thread starter Thread starter Kate
  • Start date Start date
K

Kate

In a macro I have a select statement

SELECT AVAILABILITY.BookingDate, AVAILABILITY.Period,
AVAILABILITY.Room, AVAILABILITY.Day, AVAILABILITY.BookingID

WHERE AVAILABILITY.BookingDate >= EndDate

How do I test for no records returned?

Is there some variable set that I can test?

Thanks
..
 
In code, you could check for .EOF.

Not sure how to do it in macros, as I haven't used them in
a long time.

Chris Nebinger
 
The only way I have found to do this in a macro is to use the DCount function in the condition column

DCount("[BookingDate]","Availability","[BookingDate] >= " & [EndDate])=0
 

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

How do I test for no records returned in code? 2
Help to develop more complex SQL select 1
No rows returned. Help! 1
Problem with a DoCmd.RunSQL construct 1
Can you make my SQL do what I want? Please! 1
Passing parms to a query? 1
DoCmd.RunSQL error Help 5
syntax error? Help 2

Back
Top