Progress bar indicating query progress

[paul]

I have a query that runs for about 10 minutes. Can someone tell me how I can tie a progress bar to the query to indicate the status of execution? Thanks.

 

[Joe Fallon]

If it is a single query then you canot use a progress bar.

If you are looping through a recordset (or some other counter) then you can
use a progress bar as you move through the loop. Note that if you have 5
items in the loop there is no way to say how long any one of them might
take. The bar moves 1/5 of the way regarless of the amount of time - it is
just a way to show the overal progress through the counter.
--
Joe Fallon
Access MVP

I have a query that runs for about 10 minutes. Can someone tell me how I

can tie a progress bar to the query to indicate the status of execution?
Thanks.