Process multiple records

[Brian C]

I have an Availability table that look like this:

Booking Date
Period
Room
Booking Id

I have a form to query availability and I can run the
following SQL to get a record:

SELECT AVAILABILITY.BookingDate, AVAILABILITY.Period,
AVAILABILITY.Room, AVAILABILITY.[Booking ID]
FROM AVAILABILITY
WHERE (((AVAILABILITY.BookingDate)=forms![SINGLE BOOKING
AVAILABILITY]![BookingDate]) AND ((AVAILABILITY.Period)
=forms![SINGLE BOOKING AVAILABILITY]![Combo8]) AND
((AVAILABILITY.Room)=forms![SINGLE BOOKING AVAILABILITY]!
[Combo10]));

I want to change this SQL to get all Rooms for that period
so I believe I need to code an * so do I change the last
part to be:
((AVAILABILITY.Room)="*"));

This will return multiple records so how do I then process
each record in turn to check the Booking ID field?

I want to check it for value 1 and if any record returned
contains 1 put a message on my form to say select another
room. If none contains 1 then I want to put a message on
my form to say select another date or period.

 

[Bill Taylor]

Just leave it out of the SQL

SELECT AVAILABILITY.BookingDate, AVAILABILITY.Period,
AVAILABILITY.Room, AVAILABILITY.[Booking ID]
FROM AVAILABILITY
WHERE (((AVAILABILITY.BookingDate)=forms![SINGLE BOOKING
AVAILABILITY]![BookingDate]) AND ((AVAILABILITY.Period)
=forms![SINGLE BOOKING AVAILABILITY]![Combo8])

HTH