Date

[Guest]

I have a table where I input new customers. I want the date the customers
are inputted to be logged. Can Access automatically update the date field
when a new record is created.
I have not created the form yet, just the table, and I am using the date ()
function which gives me the present date, not the date the customer was
inputted.
thanks

 

[Rick Brandt]

I have a table where I input new customers. I want the date the customers
are inputted to be logged. Can Access automatically update the date field
when a new record is created.
I have not created the form yet, just the table, and I am using the date ()
function which gives me the present date, not the date the customer was
inputted.
thanks

If you use Date() as the default value for the field then it will record the
date the record is created.

 

[Larry Daugherty]

Put a new control on your form based on your date field - I recommend
naming it something else, like "StartDate". For the default value for
the control on the form enter "=Date()"

HTH