Auto insert date

  • Thread starter Thread starter Rescueme
  • Start date Start date
R

Rescueme

I am working with MS Access97 and have a table with four fields. When I add
a new record to the table I would like the fourth field to add the current
date and time.

Field One - Ref#
Field Two - Description
Field Three - Assigned_To
Field Four - Date_Assigned

Date in the format of DD/MM/YYYY HH:MM

Thanks in advance for the help
Karen
(e-mail address removed)
 
Rescueme said:
I am working with MS Access97 and have a table with four fields. When I add
a new record to the table I would like the fourth field to add the current
date and time.

Field One - Ref#
Field Two - Description
Field Three - Assigned_To
Field Four - Date_Assigned

Date in the format of DD/MM/YYYY HH:MM
Click to expand...

Just make Now() the default value for the field.
 
Back
Top