I am currently writing a database that controls holidays in access 2000 and am experiencing a problem.

I have a holiday input form which takes the input values from an active x calender and stores the dates in 2 variables. 1) StartDate and 2) EndDate.

My Problem is simply i need to display the range of dates between StartDate + EndDate and count the Occurrence that another field is displayed on these dates.

I can get them it to display the startday and occurrence , as well as the end day and occurrence but not the middle values.

I would be very grateful for any assistance

This will output the date values to the debug window, but
you can send them to a form, report, or table as well:

Public Function DateLoop()
    Dim dtmStartDate As Date
    Dim dtmEndDate As Date
    Dim dtmCalcDate As Date

    dtmStartDate = "12/10/2003"
    dtmEndDate = "1/15/2004"

    dtmCalcDate = dtmStartDate

    Do
       dtmCalcDate = DateAdd("d", 1, dtmCalcDate)
       If dtmCalcDate = dtmEndDate Then
          Exit Do
       End If
       Debug.Print dtmCalcDate
    Loop

End Function

You can get more help on the DateAdd() function in online help.