Capture the time a query takes in running

[aqif]

Hi

I have one text box and List box on my form. Whatever I enter in my text box and press Find the List Box displays the relevant data. I was just wondering that is it possible to capture the time the query takes to display the data as my table containss over 100,000 records to search n query0 takes 5-6 secs to run. I want to capture the time it takes in secs n display on form...is it possible?

Cheers!
Aqif

 

[llkhoutx]

Save "Now()" before and after you run your query, the difference is the time it takes your query to run.