I have a table that I used to pivot from in other queries. There are only two fields, the ID field and the Date field.
When I update the database I want it to populate the date field sequentialy from date()-10 to date()+500 with each date in its own record. I would prefer to do this with SQL, but if there is an easy way to do it with VBA I am willing to learn that. I am building this database for someone else and in a years time the dates will need to be updated so I would prefer to automate this process.
Any Help would be apprecaited.
Thanks to All!!!!