Date

J

Jerry

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
 
R

Rick Brandt

Jerry said:
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
Click to expand...

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

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
 
Top