J
Jeff
I am trying to create a schedule table with a records
that show RangeStart, RangeEnd and has a check box for
every day of the week. In this record I will specify the
start date=1-1-01 and the end date =1-1-02 and check the
boxes of monday, wednesday and friday.
The query I am trying to create will show a record set
with the dates of all the monday, wednesday and fridays
between a specified range. I could make a sub that
creates a record for every one but this could cause
trouble if the ranges are very far apart. I would prefer
to have a query or something that reads the one record
and can create a recordset. Clear as MUD huh! Any ideas?
that show RangeStart, RangeEnd and has a check box for
every day of the week. In this record I will specify the
start date=1-1-01 and the end date =1-1-02 and check the
boxes of monday, wednesday and friday.
The query I am trying to create will show a record set
with the dates of all the monday, wednesday and fridays
between a specified range. I could make a sub that
creates a record for every one but this could cause
trouble if the ranges are very far apart. I would prefer
to have a query or something that reads the one record
and can create a recordset. Clear as MUD huh! Any ideas?