copying complete table over, changing the dates

[MBall2003]

i have a table with about 40 clients contract information, and the contract information only changes monthly for about 10 clients. i need to copy all of them because for my report its by month so i need that info in there each month what i want to do is copy over the current 40 clients contract info with a new date, then have the user go in and edit only the ones that need editing is there an easy way to just keep the current 40 in the table and just copy that forty and paste them to the bottom of the table with a new date (without manually doing it haha) any help would be appreciated thanks


mball

 

[cottontop]

Why create new tables.

Create a Y/N field. Modify that field based upon criteria you can set in an update query.

Then you can create a report or form that keys off that field. If it's "Y", then display to edit or print out on a list.

Once the record has been updated, set the field to "N".