How can I check date availability in a form, from a list of dates in a table?

[steve97]

Hi there, I am making a Car Rental database on Access 2010, and I have a list of the dates available to rent a car in a table. I want to be able to check what dates are available and select a date for hire in a form.

Any help on this would be greatly appreciated! Thanks, Steve97.

 

[BlueIshDan]

You're storing all dates available instead of dates not available?

 

[pr2-eugin]

First you need to create a Query to identify the available dates. This link might be a good start : http://www.baldyweb.com/OverLap.htm

 

[RainLover]

Do you have a written plan of what you want/need.

If you do which part would you first like help with.

With a copy of that plan we could help you get started by designing your tables with your input/help.

At the moment your question is too vague. Have you looked for MS Access templates. There maybe something there. Look on line as well as what comes with the Access package.