Query too complex

[marathonlady]

Does anyone else have the problem of a too complex query not running? I get the message "No current record" but then I take out one of my joined tables and the query runs.

Is there anything I can do besides making 2 queries instead of breaking the query down to 2 instead of the one?

Thanks for any help.

 

[doss]

Hello,

I don't know if this will help, but it seems like there could be two different things going on.

1. There is a problem with the way the tables are joined which is causing a conflict and no records. You can change the join type by right clicking on the line connceting the tables in your query.

2. I've have some queries that get too big with too many fields being used. One way to get around this is to select the "*" at the top of the table instead of selecting each individual fields from the tables. If you are using certain fields with criteria, you will still obviously have to have them included in the query, but uncheck the check box so that they are not visible. The query will still use them for criteria. If you use the "*" from the table and then have fields with criteria and DON'T uncheck the box, it will cause problems as well.

Hope that helps.

 

[RV]

>but then I take out one of my joined tables and the query runs. <

Conclusion; your join isn't correct and that causes the "query too complex" error.

Change your JOIN to LEFT JOIN or RIGHT JOIN depending on what's the parent table and what's the child table

RV