A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

query is too complicated



 
 
Thread Tools Display Modes
  #1  
Old October 31st, 2006, 03:56 AM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.reports
00KobeBrian
external usenet poster
 
Posts: 77
Default query is too complicated

Hi,

I try to run a query and I get an error message "query is too
complex" and not running in access 97. Can anyone please help ? Thanks.


  #2  
Old October 31st, 2006, 04:03 AM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 2,251
Default query is too complicated

If I had an error message like this and I wanted help, I would try to
provide enough information for others to help me. Is there anything you can
provide for us that might allow someone to provide assistance?

--
Duane Hookom
MS Access MVP

"00KobeBrian" wrote in message
...
Hi,

I try to run a query and I get an error message "query is too
complex" and not running in access 97. Can anyone please help ? Thanks.




  #3  
Old October 31st, 2006, 04:05 AM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.reports
NetworkTrade
external usenet poster
 
Posts: 825
Default query is too complicated

you will need to summarize the tables and the query for help with an answer.
--
NTC


"00KobeBrian" wrote:

Hi,

I try to run a query and I get an error message "query is too
complex" and not running in access 97. Can anyone please help ? Thanks.



  #4  
Old October 31st, 2006, 04:56 AM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.reports
00KobeBrian
external usenet poster
 
Posts: 77
Default query is too complicated

In fact, I just found out that there is a limit on the number of criteria in
a query, right? If I pass over the maximum, say field 1 = a or b or c....
until maximum in query, is there a workaround? Thanks.

"NetworkTrade" wrote in message
...
you will need to summarize the tables and the query for help with an
answer.
--
NTC


"00KobeBrian" wrote:

Hi,

I try to run a query and I get an error message "query is too
complex" and not running in access 97. Can anyone please help ? Thanks.





  #5  
Old October 31st, 2006, 05:26 AM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 2,251
Default query is too complicated

Why don't you just provide your SQL view and tell us what you are attempting
to accomplish?

--
Duane Hookom
MS Access MVP
a
"00KobeBrian" wrote in message
...
In fact, I just found out that there is a limit on the number of criteria
in a query, right? If I pass over the maximum, say field 1 = a or b or
c.... until maximum in query, is there a workaround? Thanks.

"NetworkTrade" wrote in message
...
you will need to summarize the tables and the query for help with an
answer.
--
NTC


"00KobeBrian" wrote:

Hi,

I try to run a query and I get an error message "query is
too
complex" and not running in access 97. Can anyone please help ? Thanks.







  #6  
Old October 31st, 2006, 05:48 AM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.reports
John Vinson
external usenet poster
 
Posts: 4,033
Default query is too complicated

On Tue, 31 Oct 2006 11:56:09 +0800, "00KobeBrian" wrote:

In fact, I just found out that there is a limit on the number of criteria in
a query, right? If I pass over the maximum, say field 1 = a or b or c....
until maximum in query, is there a workaround? Thanks.


Several. The WHERE clause as written will not work anyway!

First try a criterion of

IN ("A", "B", "C", ...)

That will get you some savings (the QTC error arises when the compiled
query exceeds 64KBytes, and each OR clause contributes some).

A better solution might be to put the criteria as records in another
table and use a JOIN, joining Field1 to the field containing the
criteria.

John W. Vinson[MVP]
  #7  
Old October 31st, 2006, 10:41 AM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.reports
David F Cox
external usenet poster
 
Posts: 493
Default query is too complicated

This message sometimes occurs because the query is just plain wrong, and
Access gets confused. Provided it is not a query that changes anything just
experimenting by removing bits and putting them back may enable you to spot
the error, otherwise post the SQL for us to look at.


"00KobeBrian" wrote in message
...
Hi,

I try to run a query and I get an error message "query is too
complex" and not running in access 97. Can anyone please help ? Thanks.





 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:45 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.