By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,574 Members | 2,960 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,574 IT Pros & Developers. It's quick & easy.

list all dates within a range except for those in table

P: n/a

I have a problem that I can't think of a (easy) solution for. I'm
building a web app (asp/access) that will allow people to book a cruise
on a 24 passenger yacht that goes around the island. I have a table
that holds the records when someone books a spot on the cruise. I have
a query that counts how many bookings there are for a particular day
subtracted from 24 so that I can see how many spots are open for that
day. I also have another table that holds the dates that the ship
doesn't run (only about 10 days out of a given year).

What I would like to do is for someone to see a list of all dates that
aren't on the "blackout" list or aren't on my query of zero spots open,
or also they could search for any date that has available slots. Say
they needed a day where 4 slots were open.

If I had every available date in a table this wouldn't be an issue. I
could easily accomplish what I wanted. But I'm wondering if there is
another way without having to input 355 days as "available" days for a
given year into a table.
Mahallo for your help,


Hau'oli Makahiki Hou - Happy New Year

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.