Complex select query

I am trying to book rooms in a hotel. A user searches for booking from
1st through 10th of a month, and if I already have a booking for 5th of
that month, then the user should get a message that booking is not
available.

What is the best way of doing this? One method I can think about it
checking the value of all records and if any of the fields contains a
value, the results are not displayed. However, I do not find this
method to be very efficient. Can this be done through a single query ?

Thanks
Pankaj

.

Relevant Pages

  • Re: Urgent Help Required
    ... FROM Driver, Booking ... hotels in London and then write a query that uses that as input to get the ... Average per hotel. ... "Running Microsoft Access 2000" ...
    (microsoft.public.access.queries)
  • Re: Hotel Booking Project Delemma
    ... when there are two different people assigned to One Hotel Booking, ... Smith and Jones booked into the same Hotel as a double ... So Smith and Jones come from the Member Table & are linked to the ... HotelBookings via the tblHotelBookingsToMembers. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Urgent Help Required
    ... London per what? ... with a subquery on the Booking table to find out which rooms are not ... The hotel considers the ... > Primary Key: RoomNo,HotelNo ...
    (microsoft.public.access.queries)
  • Re: Gay Day @ Disney Deals!
    ... special link for Priceline) - as you will see, ... Are you going to Gay Days @ Disney this year??? ... Do you want to save money on a hotel room while you're there? ... days you are booking - book 2, get offered 2 more, etc] so you can try ...
    (rec.arts.disney.parks)
  • Re: Warning: Expedia.com overcharges for room reservations
    ... advertised room rate was $102.00/night. ... That happens all the time with many of the booking companies. ... agencies purchase blocks or X amount of rooms at a certain price. ... Hotel Z contracts with online booking engine Travel ABC that they can sell ...
    (alt.vacation.las-vegas)