Hey i have to do a query where the user enters the dates he wants to hire a car - the result is suppost to show the cars that are available to rent during the dates he inputs.All the dates that the cars are rented out are in the database
Ive tried [date_start] > [date entered by user] And [date_end] < [date entered by user] but i cant get is to work!
Ive also tried [date entered by user] And [date entered by user] <> Between [date_start] And [date_end]
I just cant figure it out and i know its straight forward!!