Is there any way to time how long a query takes to run. Without using a stop watch and watching the thing ;).

Yes I have seen this done! There is information on the web somewhere! Try Rogers access library....

You can use VBA.



Public Sub TimeIt()
Dim StartTime, EndTime As Date

StartTime = Now()
DoCmd.OpenQuery "Qry_APR_Post"
EndTime = Now()

MsgBox "Seconds to run query:" & DateDiff("S", StartTime, EndTime)

End Sub

pdx_man that perfect I really should have got that on my own! Thank you!