Thread: query is too complex
View Single Post
  #2  
Old October 27th, 2006, 10:57 AM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.modulesdaovba
Allen Browne
external usenet poster
  
Posts: 11,706
Default query is too complex
Access throws this error if it cannot understand the query. There are lots
of reasons why that could happen, such as brackets that are incorrect, or
(very often) data types that don't match.

Explicitly declare your parameters (Parameters on the Query menu) for all
fields except Text, so Access knows how to understand them. If you have
calculated fields, explicitly typecast them. If you have criteria, make sure
the criteria are delimited correct: in quotes if applied against a text
field, in # if applied against a Date/Time field, and no delimiters if
applied against a Number field.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"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.