Repeating enties in MS Access database - TechRepublic
Question
September 16, 2012 at 06:33 PM
dcj1710

Repeating enties in MS Access database

by dcj1710 . Updated 13 years, 9 months ago

Hi,
I have a db that records events including their start & finish dates.
I have been able to identify which days between the 2 dates are week days but now I need to record a seperate event in the db for each date.
eg. Event starts on 17/09/20112 and finishes on 20/09/2012
Rather than record a single 4-days event on 17/09/2012 I want to record a 1-day event on each of the ,17/18/19/20.
It has been suggested that I use ‘Do Loop’or ‘Next Loop’ but I don’t understand how.

This discussion is locked

All Comments