Insert Dates into Table

[ajb_1976]

Hello,
I have a table with 2 fields - WeekID(autonumber) and WDATE(date/time). What I want to be able to do is to enter a value for the first date and then have the next 25 entries automatically entered. Each entry is to be 1 week greater than the previous entry. Ultimately giving me a list of dates, numbered 1-26, incremented weekly.
I assume the DATEADD function is to be used but i cannot determine how.
Any help / pointers is greatly appreciated.
Thanks

 

[ajb_1976]

Thanks for the reply.
In the end i resorted to creating the recordset in excel and linking my db to the spreadsheet.
cheers