Joshua Olson wrote: >>-----Original Message----- >>From: Ken Schaefer >>Sent: Tuesday, May 31, 2005 6:43 AM >> >>You can't "select" a 7 day gap. You can only select existing data. > > > Ken, > > Perhaps in a manner of speaking you can select a "7 day gap". Back around > April, there was a suggestion to Burhan's previous question about this same > project (presumably) that may be able to help here. The suggestion was to > enumerate all possible days (within reason, of course) and join the events > against that table. Using an OUTER join, it would be possible to return > only those days that have no events, thusly returning the "gap". Analysis > of this data (which can be done with one query) would allow you to locate a > range where a day, plus the 6 following days, are all within the results > set. Ken: You gave me an idea of approaching the problem from a different angle. Instead of trying to find the gap, how about if I try to find all dates that aren't taken. If there are 7 contiguous dates per hall (that are > than now()) then that would be a possible hit. The problem now has become that I have been staring at the issue for two days now, and I don't even know if THAT will work. Can anyone give me a sanity check on that?