Date of Record Creation

  • Thread starter Thread starter Pwyd
  • Start date Start date
P

Pwyd

Does access record the date a record was first created (not looking for when
it was modified)? If so, whats the function name, and required arguments?
Or macro method, if there is one. i'm not picky.
 
Pwyd said:
Does access record the date a record was first created (not looking for
when
it was modified)? If so, whats the function name, and required
arguments?
Or macro method, if there is one. i'm not picky.
Click to expand...

It does not record this, but you can do it easily.

Open the table in design view.
Add a new field, of type Date/Time.
In the lower pane of table design, set the Default Value property of this
new field to:
=Date()

If you want both the date and the time the record was created, use:
=Now()
 
Right, i have something for that. I just wanted to know if Access kept it
internally. Thanks for your response though.
 
Back
Top