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.