Geting a "Query too complex" error

[Phil Trumpy]

Using Access 2003 on Windows XP.

I designed a query that was working perfectly with my test dataset of around
200 records. When I copied it into the live version of about 1500 or so
rcords, I get a "Query too complex" error. The SQL statement is rather
lengthy. The basic idea is this:

I have a Product table where the primary key is the product number. That
joins with an offer table showing all the catalogs the item is in. It also
joins to a SKU table that shows all the different colors/sizes of that item.

I have a form with 4 combo boxes to select the criteria for the query. I
have the query written to accept the combo box value or "all" for each of the
parameters.
For example Forms!MyForm![cboOffer] or Forms!MyForm![cboOffer] = "All". One
of them is a yes/no field, so the combo is set up like this:

-1;"Re-Print";0;"Unprinted";1;"All". In the query, this is written as
Forms!MyForm![cboPrinted] or Forms!MyForm!cboPrinted = 1 ("All" did not work
for this one). I'm not sure why it works with the smaller dataset and not
the larger one. I can post the SQL if you'd like, but I don't know how well
it would paste into this forum.

Sorry if I've been too vague. Thanks in advance for any help.

Phil

 

[Phil Trumpy]

Update: After reading some posts I had not previosuly seen, I broke the
query down into two queries and that did the trick.