query too complex error 3360

  • Thread starter Thread starter thread
  • Start date Start date
T

thread

Hi all,

i build automation that collect information from a file and building
query with criteria
problem starts when the criteria is too complex
is it posible to some how increase the memory or the limit for the
query or there is another way around
 
thread said:
Hi all,

i build automation that collect information from a file and building
query with criteria
problem starts when the criteria is too complex
is it posible to some how increase the memory or the limit for the
query or there is another way around
Click to expand...

What's the query? Can you post the SQL? Optimisation of the query or a
change to the way you are running it will likely help.

Ed Metcalfe.
 
its very long query,basicly using alot of iif and criteria,i assume
that this is something that should be changed
 
Back
Top