I have created a database for a hyperthetical car hire company. I have a booking table, a customer table and a car table. If a customer books a car starting on one date and ending on another I want the database to generate a list of cars that are not being used at these times. I have worked out that:
old finish date (of all other cars) < new start date (of new booking)
How do I impliment this? I have limited knowladge of MS Access.
Iain
old finish date (of all other cars) < new start date (of new booking)
How do I impliment this? I have limited knowladge of MS Access.
Iain