Display Date Last Run on Query

[JMichael]

I have users run an append query from a button. Is there anyway I could have the date the query was last run displayed on the form by the button? Or if you know an option or alternative please share. Thanks.

[CJ_London]

the usual way to handle this is to have a date field in your table with a default value of now() - date last run will be the latest value

alternatively you will need a log table to store when events occur - and populate it when someone clicks the button - table might look a bit like this

DateRun.......Action..............User
19/7/2016...run xyz query....John
18/7/2016...run abc query....Harry