Peter
First, be aware that Access does date/times in US format ... I'm assuming
your list of dates are the 1st of March, the 1st of April, ...
If you want an Access table with the first day of each month for the next 60
months, there's a simple trick. Open Excel, put in a few dates, then extend
the range until you have all 60 (do this "down" rather than "across").
Now open Access and point to that Excel file. Import it.
Good luck!
--
Regards
Jeff Boyce
Microsoft Access MVP
Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.
Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.
You can thank the FTC of the USA for making this disclaimer
possible/necessary.