Question

Locked

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.

1 total post (Page 1 of 1)  
| 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

http://techrepublic.com.com/5208-6230-0.html?forumID=102&threadID=260882&messageID=2477107

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

HtHs

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums