query exceed system resources

[MacAcc]

Hi, so I have set up my database and some nice queries. It worked without any issue during a few days. Today, suddenly, while running an existing query an error message is poping up saying something like "system resources exceded".
Does anyone know what to do?
Tks



Markus

[ranman256]

do you have many forms open?
do these forms have sub-forms. Usu, a form with LOTS of subforms will throw this error.
or
if the query is too complex.

[CJ_London]

or perhaps you have a Cartesian query (two or more tables, no joins) and the tables have grown so the resultant recordset is too large.

and the 'query is too complex' message usually means you have nulls in the data where none are expected.

[MacAcc]

Ajax, you were right, I had nulls in a table, thanks for the help.
Cheers