Tech Support Guy banner
Status
Not open for further replies.

Adding a timestamp field in a table in Access

1K views 1 reply 2 participants last post by  RandyG 
#1 ·
Hi-

I would like to add a field to the end of my table called Timestamp. I want this field to be populated with the current time if a record is updated. I know I can set the default to =Now(), but that only sets the time and date the record is created. If I go in an update this record, that time or date does not change. Is there a way to inset a time and date that would automatically change? If not, is there an easier way then to just type in the time and date manually? Any suggestions would be appreciated. Thanks!

Ian
 
#2 ·
Have you tried =Date() ? That is what is used in the contact management database that comes with Access 2000.
 
Status
Not open for further replies.
You have insufficient privileges to reply here.
Top