ACCESS: Hidden Date Range?

By thomasmreagan ·
I would like to create a report on dates that are not indicated in date field ranges. We have a travel service, and I need a report to indicate availability (which exists between the last day of any given reservation, and the first day of the next reservation) of vacation rentals. I am having a hard time figuring out how it is done.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

You might have to twiddle about a bit

by Tony Hopkinson In reply to ACCESS: Hidden Date Range ...

but this is the way you should be going

If you had a table called Alldates
Then a simple join like
Select AllDates.Date
From AllDates,Reservations where between Reservations.FirstDate and Reservations.LastDate will give you booked
NotBooked is then simply all those in AllDates and Not in Booked.


Related Discussions

Related Forums