• Creator
  • #2171087

    Repeating enties in MS Access database


    by dcj1710 ·

    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.

All Answers

Viewing 0 reply threads