timestamp in report: showing last time table updated

[Mitchell_Collen via AccessMonster.com]

Is there a way to create a timestamp inside a report showing the last time
that a table was updated? We have a secretary who is enters data weekly. To
use the report, I'd like to be able to point out when the table was last
updated so that the report is timestamped accurate up to what date is
specified as the updated table date. Please let me know what you think can be
done.

-Misty

 

[Douglas J. Steele]

You'll have to add the information to the table yourself.

If all you care was when records were last added, add a CreateDate date
field to the table, with a default value of Now(). In your report, you'll
then be able to use DMax to retrieve the latest record date.

If you need when records where modified, again you'll need to add a
LastModifiedDate date field to the table, and put logic in the form's
BeforeUpdate event to set the value of the field to Now().

 

[Mitchell_Collen via AccessMonster.com]

Are you saying to create a column in my table named: 'CreateDate' and then
have the secretary add the current date to every record that she adds? And
then create a query to find max date?
Misty

You'll have to add the information to the table yourself.

If all you care was when records were last added, add a CreateDate date
field to the table, with a default value of Now(). In your report, you'll
then be able to use DMax to retrieve the latest record date.

If you need when records where modified, again you'll need to add a
LastModifiedDate date field to the table, and put logic in the form's
BeforeUpdate event to set the value of the field to Now().

Is there a way to create a timestamp inside a report showing the last time
that a table was updated? We have a secretary who is enters data weekly.

[quoted text clipped - 6 lines]

-Misty

 

[John Spencer]

Add a field named createdate with field type date
Set the field default to =Date() Or use Now() if you want the date and time

When the record is created the field will automatically be populated.

NO NEED for the secretary (or whoever creates a record) to do anything.

Please re-read Douglas Steele's post. IF you don't understand what he
has posted then ask for clarification (Oh! right. You just did.)

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

Are you saying to create a column in my table named: 'CreateDate' and then
have the secretary add the current date to every record that she adds? And
then create a query to find max date?
Misty

You'll have to add the information to the table yourself.

If all you care was when records were last added, add a CreateDate date
field to the table, with a default value of Now(). In your report, you'll
then be able to use DMax to retrieve the latest record date.

If you need when records where modified, again you'll need to add a
LastModifiedDate date field to the table, and put logic in the form's
BeforeUpdate event to set the value of the field to Now().

Is there a way to create a timestamp inside a report showing the last time
that a table was updated? We have a secretary who is enters data weekly.

[quoted text clipped - 6 lines]

-Misty

 

[Mitchell_Collen via AccessMonster.com]

OK, I just needed clarification on how to set a default value on a column.
Thanks for helping me. The change works really well now and it gives me ideas
on other column attributes that are possible. So again, I appreciate both of
your help! (despite John's sarcasm).

Misty

Add a field named createdate with field type date
Set the field default to =Date() Or use Now() if you want the date and time

When the record is created the field will automatically be populated.

NO NEED for the secretary (or whoever creates a record) to do anything.

Please re-read Douglas Steele's post. IF you don't understand what he
has posted then ask for clarification (Oh! right. You just did.)

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

Are you saying to create a column in my table named: 'CreateDate' and then
have the secretary add the current date to every record that she adds? And

[quoted text clipped - 15 lines]

[quoted text clipped - 6 lines]
-Misty