Creating an Appointment Schedule Database 1

[SgtBeck]

So here is my dilema... I am trying to utilize MS Access to be able to generate queries that will allow users to select a day of the month and be able to see what appointments are available. Here is my big problem... I can't figure out how I can get the queries to be able to recognize that appointment times on Monday - Friday are form 7:45 - 9:45 AM and on Wednesday have additional appointments from 3:00 - 5:00, I also am trying to be able to have the query read from another table that has dates which we are closed that way people will not be able to see appointments on days that are not available without having to manually input the dates that correspond to only weekdays (example: 30 Sep 06 = Saturday).

 

[SkipVought]

Hi,

Where (Format([ApptDateTime],"hhnn") Between "0745" and "0945" Or Format([ApptDateTime],"dddhhnn") Between "Wed1700" and "Wed1900")

Skip,

_[red][/red]