Test for no records in macro

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
..
 
C

Chris Nebinger

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
 
T

T'Kai

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
 
Top