the last updated date and time

[venu]

how i know the last updated date and time of database, and How the last updated date and time appear on a particular report. HELP ME PLS.

[pkstormy]

create a text box on the report (usually the report footer). for the control source of that text box put: =Now() or =Date()

Format the field appropriately (ie. short date, long date, etc...)

That shows the current date/time on the report.

If you want to record (in a table) the last date/time the report was last executed, you'll need to write some vba code (or an append query) to write to a table which has 2 fields (ReportName and DateTimeExecuted) and then populate that table appropriately when the report is run.

[venu]

create a text box on the report (usually the report footer). for the control source of that text box put: =Now() or =Date()

Format the field appropriately (ie. short date, long date, etc...)

That shows the current date/time on the report.

If you want to record (in a table) the last date/time the report was last executed, you'll need to write some vba code (or an append query) to write to a table which has 2 fields (ReportName and DateTimeExecuted) and then populate that table appropriately when the report is run.

How to papulate the table when the report is run.