timestamp in report: showing last time table updated

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mitchell_Collen - 04 Dec 2007 22:07 GMT

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

Reply to this Message

Douglas J. Steele - 04 Dec 2007 22:39 GMT

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().

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> 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

Reply to this Message

Mitchell_Collen - 06 Dec 2007 14:20 GMT

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.
>
[quoted text clipped - 11 lines]
>>
>> -Misty

Reply to this Message

John Spencer - 06 Dec 2007 14:38 GMT

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

Reply to this Message

Mitchell_Collen - 06 Dec 2007 16:33 GMT

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
[quoted text clipped - 18 lines]
>>> [quoted text clipped - 6 lines]
>>>> -Misty

Reply to this Message