Use updated info but retain history 1

[PlsHlpKat]

I have an HR system in Microsoft Access, one table lists pay rates, merit increases, status changes etc. but I need only the current pay rate and information to show up on the reports and main form. As it stands right now the reports lists every pay rate and status change. I do need to keep a history of all.

 

[nicsin]

Are you storing a timestamp of each action? Instead of updating the record each time the pay rate changes, you could insert a new record with a different timestamp. You can always access the latest one by using the MAX() method.

select MAX(<timeStamp>) from <myTable>

 

[PlsHlpKat]

Yes I am inserting a new record for each change but I am not clear on what you mean by a time stamp, could you please explain?

 

[nicsin]

Timestamp is a spesific point in time. So you can store the date and time that the new record was inserted and use the MAX() to retrieve the last one. Is it clearer?