JabberWocky

I need to find out how to get the date a record was last added to a specific table. Possible even the last record added to a table relating to the Primary Key in another table if it's possible.

You see, I am designing a back to work interview system and could really use the facility to view the last time a sickness record was added for a specific employee.

Thanks in advance,

JabberWocky

Thinker

I think you will need to add a timestamp field to the table. Everytime you add a row, you place the current time and date in this field. Then, when you need to find the last one you can Order By Desc this field and if your SQL supports it use the TOP 1 in the Select clause. If it is related to the Primary key in another table then it is just a join.