query is too complex

  • Thread starter Thread starter 00KobeBrian
  • Start date Start date
0

00KobeBrian

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.
 
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.
 
Back
Top