I wnat a table displaying all dates 2 years from the current date

[Mike]

Hi,
I want to create a booking system for a caravan site rental with a table
containing all the dates 2 years into the future from the current date.
I thought of having a tabl with every date about 100 years into the future
and then using a query to narrow it down. But this seems a sloppy method.

Any suggestions would be extremely appreciated.

 

[Rick B]

You can do this, but it would not fall under normalized database design.

You would not need a record for a date on which the particular unit was not
rented.

You should have a table for each of your rental units, then a separate table
with customer info, then a thrid table that contains the unit, the dates
rented, and the customer information.

Ther would, of course, be more data depending on your specifics, but this is
the minimum that I would think you'd need.

Rethink your design.


Rick B