Q. How do I save the current date in a table ?

  • Thread starter Thread starter Jim Jones
  • Start date Start date
J

Jim Jones

Hi,

I've posted this before, and I forget. It's one of those things I just
can't fix in my mind, on how to do.

I use Access 2K.

I have a records table, and I want to save the current date and time
in the date column.

Example: Employe 3034, on 9/22/2003, finished project.
I want that to be saved in the table.


Thanks,
Jim
 
Use =Now() as the Default Value for the Control that holds the Date and
Time. Don't use either Date or Time as the name of that Control or Field,
because they are Access reserved words and it could cause a problem.
Click to expand...
I should have said that I tried Now() as the default value, and this
is what keeps "updating" the date in my table.

I want to record it as a timestamp.

Jim
 
Back
Top