Multiple Days Between two Dates

D

D. Mullins

I have a DB for tracking education classes. Some classes meet once/week for a set period time between two dates--StartDate and EndDate. Some courses meet twice/week. Some courses only meet once--StartDate and EndDate are equal. I want a report which will list all of the days which the classes will meet (format: Monday, 10/27/03). I can write expressions in a query to determine how many days/week the class meets--FirstDay:DatePart("w",DateStart) and LastDay: DatePart("w",DateEnd). If FirstDay=LastDay, then 1day/week; otherwise 2 days/week. Also can calculate how many weeks the class will meet: DateDiff("ww",StartDate, EndDate). Now what I need to know is how to use this information to list the dates. I'm thinking some actual code will need to be written.
 

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