Room Scheduler

[osullipa]

I want to build a room scheduler. Before I get too far in to my first attempts, does anyone know if there any examples out there I can use to give me ideas?

If not I wonder can anyone advise me as to a difficulty I currently can see with what my attempts so far. I have built a very basic database with fields for each room and time slots through each day. This works ok. The problem I see is finding a way of setting a room booked for say "every Thursday between 14.00 and 15:00". I have considered using a query to do it but cannot see how to formulate it.

Thanks in advance for any help you may offer.

Peter

 

[reclusivemonkey]

Hi Peter,

You can find the day of the week using;

Datepart("w",[I]YourDate[/I])