I want to retrieve dates between two dates the user has specified e.g. say the user enters the dates 01/10/2010 amd 05/10/2010 i want to be able to get the dates inbetween the dates entered by the user e.g. 02/10, 03/10....

What possible way is there to do it?

Thanks
tom

Create a date data type.
Set it to the initial value.
Use in in while stmt incrementing the date with the DataArr function

NextDay = DateValue(DateStart.Text)
LastDay = DateValue(DateStop.Text)

While NextDay < LastDay
  NextDay = DateAdd("d", 1, nextDay)
        '
        '
        [I]' Your code to process each date[/I]
        '
        '
wend