need Creating monthly reports and forms

[Belcebu]

I am trying to create a database about employee monthly evaluations. I have my main table where i put the employee's name, ID# and Dept #. These values are permanent. In the other hand i also have values that differ each month such as dates due for the revisions, dates the evaluation is sent and general comments. I want to be able to input information into a form to add values but these values all go into the same table so when i start a new month if i insert the new data it will overwrite the data from the previous month.

Is there a way to make it so that the data entered in a form will be saved into a newly generated table that can be renamed for the current month, or if not what other alternatives do I have to solve this issue?

Any help would be greatly appreciated,

Belcebu

 

[gol4]

I highly recommend against another table

consider adding a field to the table call it what you want but maybe currentmonth then store perhaps the first day of each current month or even the date then you can simply
query against that field.

with a new table you would need to look at up to 12 tables to look at the employees previous years history.