Table based on calendar of days?

[Penny Meholick]

I need to create a database to track the rental of motel rooms. The user
would click on a date to reserve a certain room, and check customers in/out,
and keep track of payments.

I've created many databases before, but I'm at a loss how to begin one that
is based on a calendar of days.

Can someone point me in the right direction to get started? Maybe an
example to base it on?

Thanks!

 

[ChrisJ]

You should not have a table based on days, but rather a
table of bookings. Something like...

tblBooking
BookingDate DateTime
RoomNumber Number
PersonID (or name) number or text
Confirmed Yes/No
etc.

I have a skeleton Timetable database which uses the same
principles. If you would like a copy, contact me on
Chris
at
mercury-projects
dot
co
dot
nz