Is there a way to automatically generate a date create or date modified stamp
in the table.
--
Rose

At the table level, you are somewhat limited. For 'date created' you can add a field called DateCreated set to date/time datatype and a default value of
Date() (or Now() if you'd like the time recorded with the date). For the date modified though, you need to do this in a form (and also restrict users to modifying data only at the form level). Include the DateModified field in the recordsource for your form, and in the BeforeUpdate of the Form put the following:
Me!DateModified = Date()

(again you can use Now() instead if you want to include the time.

--
Joan Wild
Microsoft Access MVP
"Rose" <(E-Mail Removed)> wrote in message news:703EF5CC-F5DB-4175-92CC-(E-Mail Removed)...
> Is there a way to automatically generate a date create or date modified stamp
> in the table.
> --
> Rose