Date Display when Query Last Run

[JMarcus]

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.

 

[jdraw]

Record the DateofQueryRun in a table.
Then get the most recent date from the table and populate a control on the form.

 

[JMarcus]

Perfect. Already have the column set up with date and have done that in the past. Im having a problem populating it on the form. Should be MaxOfDate Appended?

 

[jdraw]

Show us the table and form.

 

[CJ_London]

Also answered here - either this is a homework question or the OP is double posting.

http://www.accessforums.net/showthread.php?t=60858

 

[JMarcus]

Posted twice. Middle name is Michael. Thanks. I'll try to figure it out.