Limit on complex SQL statements

[jpmillr1]

Is there a limit to the complexity of SQL statements? I successfully wrote a query based on 6 combo boxes, and it worked once or twice. But then it stopped working and an error box said it was too complex. What gives?

Thanks,
John

 

[DanChard]

There's no formal definition (as far as I know) on when a query becomes too complex based on the amount of combo boxes it uses! If you paste the SQL behind the query there's a chance that somebody here can re-write it for you so that it works...