Hello Everyone,

Just wondering if anyone out there could shed some light on why, a query would pause for 10 to 20 seconds in mid query. Granted it is a very complex query relying on other pre-queries and links together on mulitple relationships between the queries and tables that create it but, it seems like there should be a way to make it run quicker.

Thanks in advance for any input.