LincolnMarkV
Programmer
Hello friends,
I am working on a scheduling database and have run into a snag. I have a form which has both a start date and an end date text box. I also have 7 checkboxs that represent each day of the week. When I check a checkbox, it will write the day of the week in a hidden textbox. I use the data in the hidden textboxes to supply the criteria to a listbox query that shows the instructor's existing schedule based on the date range and the days of the week selected. This all works perfectly.
What I am looking to do now is to return all of the days of the week that fall between the date range and the specified day(s) of the week. For example:
frmCorpSchedule (This is my form)
txtStartDate = 7/1/09
txtEndDate = 7/8/09
chkMonday = true
chkTuesday = true
txtMonday = "Monday"
txtTuesday = "Tuesday"
My query should return:
7/6/09
7/7/09
Please advise on how I would accomplish this using a query.
After I have the dates, I need to compare them to the instructor's existing schedule to ensure there are no conflicts.
Thanks!!!
I am working on a scheduling database and have run into a snag. I have a form which has both a start date and an end date text box. I also have 7 checkboxs that represent each day of the week. When I check a checkbox, it will write the day of the week in a hidden textbox. I use the data in the hidden textboxes to supply the criteria to a listbox query that shows the instructor's existing schedule based on the date range and the days of the week selected. This all works perfectly.
What I am looking to do now is to return all of the days of the week that fall between the date range and the specified day(s) of the week. For example:
frmCorpSchedule (This is my form)
txtStartDate = 7/1/09
txtEndDate = 7/8/09
chkMonday = true
chkTuesday = true
txtMonday = "Monday"
txtTuesday = "Tuesday"
My query should return:
7/6/09
7/7/09
Please advise on how I would accomplish this using a query.
After I have the dates, I need to compare them to the instructor's existing schedule to ensure there are no conflicts.
Thanks!!!