Timestamp For last table update

[abledog]

Hi, I am looking for the timestamp to see when was the last time a table was updated.

I update the table by going into the table itself and pasting in new records, I don't update the records from a form (in which case I could have just recorded the time stamp)....


Is there any way of doing this ..?

Thanks for your help...!

 

[boblarson]

Is there any way of doing this ..?

Nope, not really.

 

[Mike375]

If you are pasting records as Paste Append then what about adding a field with default as Now() and make it the last field so it does not mess up your paste order.

 

[abledog]

That Works....Thanks a lot Mike.....appreciate your help...!

 

[Pat Hartman]

Paste append is a spreadsheet technique. Append queries are safer and do not rely on column names or order.

 

[Mike375]

Paste append is a spreadsheet technique. Append queries are safer and do not rely on column names or order.

Hence..."and make it the last field so it does not mess up your paste order"