Checking values in returned records

B

Brian C

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 multiple records:

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]));

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.
 

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

DoCmd.RunSQL error Help 5
Process multiple records 1
Syntax error 1
Too few parameters error. Help needed 1
Help passing parameters to a query 1
syntax error? Help 2
Process records from a query 1
Put message to form 1

Top