Set Date Stamp

[rocket]

I want to set a date stamp for the date a record is created without the
field being changed everytime the record is accessed, how do I do this?

J

 

[Steve Schapel]

Rocket,

Set the Default Value property of the field in the design view of the
table to Date()

- Steve Schapel, Microsoft Access MVP

 

[Allen Browne]

1. Open the table in design view.

2. Add a Date/Time field to store the record creation date.

3. In the lower pane of table design, set the Default Value property to:
=Date()
Alternatively, if you want to store the time as wall as the date, use:
=Now()

 

[rocket]

Thank You Steve & Allen