date modified in report

[Rasha]

please i wana to insert a text box in the report design that show the last date in which the data was modified ... any body can help me ?

[NTC]

I presume we are not talking about the 'report date' which is simply the current date when the report is generated....as this will change each time you reopen the report..... so this 'last modified date' must exist somewhere in the database for long term record - - and which case it can be displayed in the report either with the record source or as a small sub report - it will depend on how your data is structured and where that date field is located....

[Rasha]

sorry ... i mean that in the table design i wanna to insert new field that named date modified ... each record in the table is a separate data ... so when i print the report ... it will show only one record ... my question is how can i make the field to automatically field with last modified date and then i show this field in report
as now() which show the created date for each record ... i wanna another thing to show the modified date

[June7]

Do you want to retain history of each modification? That would be rather complicated.

If you just want to change the field value, use code in the BeforeUpdate event of form. VBA example:

Me!ModifyDate = Now()