Can Access retrieve date data was entered?

[Tara C.]

I have a simple 1-column database that lists names of projects
alphabetically. Is there a way to add a 2nd column that lists the date when
each project was entered in the database? We did not enter this information
originally, but would like to see it now if possible.

 

[John Spencer]

No, Access does not store when a record was created or modified. So there is
no way to get that information.

You can store the information for future entries.

Add a field to your table - CreatedOn and set its type to DateTime. Set the
default to Date(). That will automatically set the value of CreatedOn to the
current system date. Use Now() if you want the date and time.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Jeff Boyce]

That depends...

If you wish to add a new column and ENTER the dates when the projects were
added, you can do that (see John's response).

If you wish to add a new column and have Access automatically add when the
projects were added, you can't do that (see John's response).

Regards

Jeff Boyce
Microsoft Office/Access MVP