Date of Record Creation

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.
 
A

Allen Browne

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()
 
P

Pwyd

Right, i have something for that. I just wanted to know if Access kept it
internally. Thanks for your response though.
 
Top