Recent content by darkhelmutis

Bob- Thanks for the help. I will see if I can get this code to work more reliably than my current incarnation! DH

Is there a way to measure how long it takes a query to run in Access 2007? I have a macro that will do it, but it is somewhat buggy i.e. after it runs Access tends to lock up, not show the results, etc. Is there a better way to do this? Using a stopwatch isn't accurate enough, but I thought...

I am looking for some guidance on how to calculate the amount time it takes for queries to run in two different version of a database. So, from the switch board I select which action to take and would like to have something (a macro I presume) to capture the time at the start of the query...