date that query was last run

[IANGRAND]

Is it possible to set the date in a textbox when a specific query was last run.

Ie i need the user to know the date that a specific table was last updated through a query.

Cheers

Ian

 

[koresnordic]

The only way I can think of is for a seperate table to be created. this has the fields

[date]. Using an update query to change the [date] field whenever a table is updated. So the order of events would be: query to update original table, query to update [date] against the relevent

record. You would need several quries (one for each table to be refered to). They may (and prov is) a better way of doing this, but I leave that upto the the MVP's



Graham