Access Date/Time

  • Thread starter Thread starter Joe Sutphin
  • Start date Start date
J

Joe Sutphin

Is there any way to know the date/time a record was added to a table? Does
Access have some sort of hidden value a user can query to ascertain the
information? TIA.
 
Joe

Open the table in design mode. Add a DateCreated (date/time) field. Set
the Default property of that new field to:

=Now()

Everytime a new row is added, the DateCreated will be populated.
 
That's a good tip, but what about records that already exist? I need to know
when they were added.

Joe
 
That's a good tip, but what about records that already exist? I need to know
when they were added.
Click to expand...

If you weren't recording it at the time the record was created, there
is literally no way on Earth to know. That information is not recorded
anywhere in Access.
 
The only way is to use a form to update the table, and set the field's value
in the Before_Update event.
 
Back
Top