Actually after reviewing the model, I don't like it. This one might be
better
http://www.databaseanswers.org/data_...tion/index.htm.


--
Duane Hookom
MS Access MVP


"law" wrote in message
...
I'm not to sure how to query this database design though. Can anyone
please
help?

"Duane Hookom" wrote:

Check this possible data model
http://www.databaseanswers.org/data_...tels/index.htm.

--
Duane Hookom
MS Access MVP


"law" wrote in message
...
As part of a hotel system, i need to create a booking system with
customers
being booked into rooms on days of the year.
I am looking to query a table(/s?) for the fields of: arrival date,
departure date, occupancy the customer requires and whether they
require
an
ensuite room or not.
I am wondering what format my table/s should take to achieve the
desired
outcome of telling a customer whether there is a room free or not.
Any help would be greatly appreciated.