Date of Record Creation

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

 

[Allen Browne]

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.

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

 

[Pwyd]

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