Unmatched Query - How to look for available cars on a specific date?

[David Biscan]

Hi,

I struggle with my project big time... I am creating a database based on a car rental.

I am trying to create a query where after entering a specific date, it will list all of the cars that are NOT BOOKED and are available on that date.

I have created an unmatched query, and the criteria for "Booking ID" is "Is Null". It lists all the cars that are available at any day in this moment in time. After entering "[Enter Date]" as a criteria for "Date" field and running it, it doesnt show any results. :(

Help!

[Rabbit]

You'll want to filter for all cars where the date you enter is not between the start and end date of the reservation.

[David Biscan]

Thanks Rabbit for your reply.

So what is the solution for my problem? The rental is takes only 1 day, therefore I have not got sucha fields as "Start date of a rental" and "End date of a rental".

I am still confused, and have no idea what to do and what I need to enter as criteria in the query design.

Please help Rabbit :)

[Rabbit]

Then that's easy, all you need to do is

SELECT * FROM TableCars
WHERE DateField <> [Enter Date]

[David Biscan]

You might actually laugh at me right now, but as an amateur, I would like ot ask you where do I enter this?

Thanks!

[David Biscan]

GOT IT WORKING!

Thanks Rabbit! Your the man!