Repeating enties in MS Access databaseLocked
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.