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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|