Is there a way to have an automatic date stamp when some enters data into a record.
R Rose Nov 17, 2007 #1 Is there a way to have an automatic date stamp when some enters data into a record.
A Allen Browne Nov 17, 2007 #2 Access doesn't do this for you, but it's easy enough. Open the table in design view. Add an extra field of type Date/Time. Set the Default Value of this field to: =Now() If you only wanted the date (not the time as well), use: =Date()
Access doesn't do this for you, but it's easy enough. Open the table in design view. Add an extra field of type Date/Time. Set the Default Value of this field to: =Now() If you only wanted the date (not the time as well), use: =Date()
