thanks for that - John and Duane have responded to this.
On Friday, 11 November 2016, 16:26, "email@example.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
>>I have a query which causes the message 'Access is not responding' - it is quite a complex query in that it has about 12 fields which use fairly involved dcounts.
Is it possible that a query simply becomes too 'big' to run?
Phil - yes it is very possible to have queries too complex to run efficiently. Heavy reliance on domain aggregates like DCount() will slow things down quite a bit. Maybe it's tile to re-evaluate your query structure.
If you post the SQL statement here someone might find a better solution for you.
Bill Mosca, Founder - MS_Access_Professionals
My nothing-to-do-with-Access blog
Posted by: Phil Knowles <firstname.lastname@example.org>
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (36)|
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.