|
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!!)
Navigation:
[Reply to this message]
|