Question Locked
0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.
2 replies
by thomasmreagan Accepted solution
Clarifications
by tony hopkinson Accepted solution
but this is the way you should be going
https://www.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
This discussion is closed to new replies.
Trending Software posts
Sort by Trending
Question Unanswered
Icons, favicons and merch graphics on Squarespace: my workflow for getting
0 helpful
0 replies
Discussion
Network Printer Works for Everyone Except Me
0 helpful
10 replies
0 helpful
4 replies
Discussion
Is There any Reverse Video Search Tool
0 helpful
8 replies
Discussion
Useful software Tip or Shortcut
0 helpful
0 replies