Time Stamp/Time Tag

[C. Brennan]

I'm working with a program that is looking for an element that is updated
each time a change is made to a record. They refer to it as time tagging.
How do I identify/create a field in my tables in Access 2000 that will
accomplish this?

Thanks for your help!
C. Brennan

 

[Rick B]

Do a search. This is asked and answered all the time. Search for
"TIMESTAMP".

 

[Douglas J. Steele]

Assuming you're using a form for all of your updates, put logic to update a
LastUpdatedDTM field in your record in the form's BeforeUpdate event.

If you're using queries for updates, you can specify Now() as one of the
fields to update the LastUpdatedDTM field.

It's not possible to do if you're updating the tables directly.