Table

[NEEDHELP123]

I have a table where inputs are stored. Is there an easy way to make copies of, for example 2006 data and paste to the same table but now calling it 2007. Also, as this is happening users are still entering data into 2006.

 

[Mile-O]

Why would you want to post 2006 into a table for 2007 data?

And, more importantly, why would you have a table for seprate years. The proper method would be to have one table to enter such data into and add an extra field that stores the year or, even better, a date within that year that has some relevance to the data so that you can just query the table on any date range you wish.