enter start and end date and get all dates between

[MikeydJR]

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

Returns

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.

 

[Stevehewitt]

Assuming you have a "Dates" field in the table that you store the data, and they are all formatted the same then you can have a query where under the criteria for the dates field have:

between [START DATE] and [END DATE]

When this is ran you will be asked for a start date, and an end date. Access will then display all dates that are in the table between the criteria you enter.

If you were after a way to do this without having every single date entered into a table then I suggest you re-post in the VBA forum (Forum707). I'm still classed as a newbie with VBA so I cannot help!

Hope this helps and Good Luck,


Steve.
If a post help you out then give it a star!

 

[RoyVidar]

A not very documentet way is:

Sub dates()
dim lCounter as long
for lCounter = Me("txtStartDt&quot to Me("txtStopDt&quot
Debug.Print Format(lCounter, "m/d/yy&quot
next lCounter
End Sub

(you could of course add the dates to a control on a form, or whatever...)

HTH Roy-Vidar

 

[MikeydJR]

Thanks, Steve. I think I will repost in the VBA forum. I need the resulting dates to be in a table.