Expression too complex to be evaluated

H

HeatherD25

Hi,

When I'm opening a report I get the message "This expression is typed
incorrectly, or it is too complex to be evaluated. For example, a numeric
expression may contain too many complicated elements. Try simplifying the
expression by assigning parts of the expression to variables."

I'm using Access 2007 (just upgraded from 2003). I didn't seem to get this
error in 2003. This report is based on some 3 queries.
- The 1st query runs and limits the data set to dates that are selected in a
combo box on a form.
- 2nd query runs and sums the data for all dates within the data set.
- 3rd query runs and calculates some percentages, etc.
The queries work great and when I run each of them and they gives the
information I need without a problem. But, the report that this last query
is based on gives the message above. Any ideas what could be causing the
problem?

Thanks!
Heather
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report parameter "too complex" 8
Expression error 7
Expression too complex? 1
Chart not working in report - Help requested 5
Print Error: ....too complex to be evaluated 1
This expression is typed incorrectly, or it is to complex to be ev 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Error Message When Using a Sub Report 1

Top