Microsoft Access Data Base (Auto Date/Time Stamp)

Hi,

I am working on an Access Data Base and need to incorporate an
auto date/time stamp but do not know how. I did locate the format
function that allows for that type of data to be formatted correctly
but do not know how to enter the formula for this; can you help?

Thanks,
Sandi

To record when a new record was created, just add a Date/Time field to your
table, and set its Default Value property (in the lower pane of table
design) to:
=Now()

If you want to also record the last date/time when the record was updated,
you will need to use some code in the BeforeUpdate event procedure of the
form where the updates take place.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

wrote in message
...

I am working on an Access Data Base and need to incorporate an
auto date/time stamp but do not know how. I did locate the format
function that allows for that type of data to be formatted correctly
but do not know how to enter the formula for this; can you help?

Thanks,
Sandi