Need to create a history table

[Jan at air-flo mfg]

I am in a quandry in trying to create an Access table that will hold
historical data of employees (i.e. wage increases, absenteeism, job movement,
etc.) I would appreciate any tips I could get.

 

[Rick B]

Have you done a search? Look for previous posts using the term "audit
trail". You should find many helpful posts.

 

[FSt1]

hi,
most people call them audit trails. i perfer the term history. but check
these 2 sites

http://support.microsoft.com/default.aspx?scid=kb;en-us;197592
http://rogersaccesslibrary.com/download3.asp?SampleName=AuditTrail2.mdb

roger's site has a lot of goodies.
you can also do a google on audit trails to find more.

Regards
FSt1