Is it possible to archive previous records either in Access or in an Excel file to keep for historical data?
Here is the problem:
I want to create a training database for employees. This database will let us know which trainings are due for an employee. The problem is; I want to be able to not only enter the date that training was done, but NOT overwrite any previous training for the same training.
Total Quality: 3/7/02
Quality Refresher: 3/7/05
Quality Refresher: 3/7/08
I don't want to lose the previous dates of training.