Paste date

[Rick]

I have a data base that I would like every time I add a
record to it the current date would be added and kept.
What would the best way to do this be? So if I added 1
record or 100 records today the date added would show
5/18/2004. Then if tommorow I added 1 or 100 records the
date would be 5/19/2004. That way I could sort by dates
that I added something.
I guess I will need to make a field for the date but how
do I get the date to be in there automaticly without
having to type it in each time.

Thanks Rick

 

[Allen Browne]

Open your table in design view.

Enter the new date/time field, and in the lower pane, set its Default Value
to:
=Date()

If you wanted it to record the time as well as the date, set the
DefaultValue to:
=Now()

 

[Reggie]

Rick, Open your table in design mode. Add a new field to the bottom(i.e..
dtToday). In the right column set the data type to Date/Time. At the
bottom of the screen set the Format to what you want(i.e. Short Date). In
the Default Value type in "=Date()" (no quotes). Now for every new record
the current date will be added.

 

[support]

I am from the Access support department at http://www.enterpriseprojectconsulting.com and we would be happy to assist you in resolving your issue

Thank you

Enterprise Project Consulting