Getting dates from days of the week

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top