Storing the Date the Record was entered into a table

[landerson]

Hello everyone. I am wanting to store the date the record was entered into the table. But I don't want the users to have to type this in; I thought that Access could grab the date from the system date.

I am new to this and I looked at the Date function but I am thinking it will just always update to the current system date.

Thank you very much if anyone could point me in the right direction.

 

[Malcy]

Add a field dtmRecAdded and set it to date format with the default value being Now()
Every time a new record is added it will catch the date and time
Hope this helps

 

[neileg]

In the default value property of the field enter =Date()

 

[landerson]

Thank you very much everyone. It worked.