I have two fields in an Access Database:

StartDate EndDate
1/12/99 6/2/99

Is there any way I can assign a variable to the values of these two fields and all of the dates in between.

i.e

I want to end up with something like:

sDate1 = 1/12/99
sDate1 = 2/12/99
sDate1 = 3/12/99
sDate1 = 4/12/99
sDate1 = 5/12/99
sDate1 = 6/12/99

If this is possible how could I code it in VB ?