Use dates & Append Query to populate table

[Mmattson]

I am looking for advice on the folllowing task before I begin it. I have done some searching and haven't found a comparable question.

I want to enter the [beginDate] and [endDate]. Once I've done that, I want to populate by appending to a table all of the pay periods in the given time period. For example...

beginDate:[] "2/12/05"
endDate:[] "4/2/05"

...would append the following weekend dates data to a Periods table....

2/25/05
3/11/05
3/25/05

I figure I can do this by an append query or VBA. Which is the most practical and efficient?

 

[Eckerslike]

The easiest way to do this, would be to simply create a table with all of the pay dates in. Then create an append query using this table and put in the criteria:

Between [Start Date] And [End Date].