Enter start and end date in a form, get all dates between

[MikeydJR]

I'm trying to create a form where I enter a start date and end date and create/update a table with all dates between
EX:
start date 8/1/03
end date 8/7/03

Returns Table named ALLDATES

datefield
8/1/03
8/2/03
8/3/03
8/4/03
8/5/03
8/6/03
8/7/03

TIA for any advice.

 

[SkipVought]

Hi,

FillDate = StartDate
Do 
 StartDate = StartDate + 1
 LoadTable
Loop Until FillDate = EndDate

Its a snap to do in Excel.

Hope this helps

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com