Posted by Buzby on 10/22/08 11:33

"Jens" <Jens@sqlserver2005.de> wrote in message
news:1133367144.886784.319920@z14g2000cwz.googlegroups.com...
> Ok that why posting DDL and sample data is so important if you are
> stating a problem in here:
>
> www.aspfaq.com/5006

I don't thinks thats possible with access. I'll do my best to explain:-

AvailRoom ID=8 AvailDate = 12/09/2005 AvailDayShow=1
AvailRoom ID=8 AvailDate = 12/10/2005 AvailDayShow=1
AvailRoom ID=8 AvailDate = 12/11/2005 AvailDayShow=0
AvailRoom ID=8 AvailDate = 12/12/2005 AvailDayShow=1
AvailRoom ID=8 AvailDate = 12/13/2005 AvailDayShow=1

The room is bookable for any given day if AvailDayShow = 1.

So in this example If I wanted to book 2 nights 12/09 and 12/10 the rooms is
bookable - however, if I wanted to book three nights from 12/09/2005
AvailDayShow = 0 on the 12/11/2005 , so the room is not bookable.

Hope this makes it clearer! (Sorry did say newbie at the start!!)

[Back to original message]