Populating 10+ Years of Dates Table

[Mordred]

Hi all,

I have created a Dates table in Acces 2003 that has the following attributes:


DateID (PK), Days, Months, Quarters, & Years. I was wondering if there was a way to populate this table, which will span 10+ years, without manually doing it? While I have worked with Access in the past, I have yet to create a table like this. Any help is appreciated.

[pbaldy]

Probably, but it's not clear to me what the data would look like. Generally, a For/Next loop or a Do/While loop that steps through your dates, using the AddNew method of a recordset to add records.

[ajetrumpet]

it should also be noted that a function to do this, using days over a 10 year timeframe would equal:

365*10 = 3650 records ~ <.5 seconds of processing time.

100 years = 36500 records ~ 2-3 seconds of processing time, if that.