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
 
Back
Top