My swithboard has a button wich runs an Update query (it updates one table
fields from another table linked to Excel datasheet). I run the query only
when the data in Excel has been changed. At times I have to print some
reports with old unupdated data and only then perform the Update.
I'd like to add LastUpdate field on the switchboard, wich will show the date
when the query was run last time (in other words, a date the data is updated
to).
Creating Date field with a default value of Now() in the updated table and
then pulling it's DMax woud not help, cause the query is not adding new
records, so the max value will remain always the same (the same value of the
date of creating the records).
What can be done? Is there a way to timestamp query-run or table's
data-update?