Square pegs in Round holes

G

Guest

I Have a Hire Dates Table, and to keep things simple, the car has hire dates
booked between 01/01/07 to 10/01/07 and another between 20/01/07 to 30/01/07.
How do I test by querying the table that the dates are free for a further
booking on the 11/01/07 to 19/01/07, i.e. prove the spaces between records.
Beware, the query must not be able to bridge an existing booking, i.e.
31/12/06 to 11/01/07
It probably seems quite simple but it's running me round in circles.
Many Thanks in advance for any assistance.
Andy....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tracking Time in my Spreadsheet 4
Updating records in a table dependant on criteria in another table 1
How to Round a Date to a Month 2
Summarise data by Month 7
VLOOKUP and IF Functions 2
Picking out a Period, in relation to certain cells 6
Counting shifts lost between two dates 4
Getting rid of text in a data set and replacing it with an average ofthe numbers either side of it. 2

Top