Minggu, 13 November 2016

Re: [MS_AccessPros] Spacing for Query List

 

Hi Bill
thanks for that - John and Duane have responded to this.
 
cheers
 
Phil


On Friday, 11 November 2016, 16:26, "wrmosca@comcast.net [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.

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com

 


__._,_.___

Posted by: Phil Knowles <pdk444444@yahoo.co.uk>
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.


.

__,_._,___

Tidak ada komentar:

Posting Komentar