'Expression too complex' message?

[stevemccauley]

My report is displayed perfectly in print preview mode, but when I go to print it I get:

"Expression is typed incorrectly, or is too complex to be evaluated. Example, a numerical expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables."

And the printed report is missing one of its subreports. The missing subreport is the only one with a query in it that combined 2 tables.

What can I do?

 

[JMS]

If you are using a really old version of access (i.e. 2.0) then this is a limitation of the program... you have to break your calcualtion up into a group of smaller queries.

I do not know why this would appear in a newer access version. Still, breaking up the SQL work into smaller queries could help.