Expression too complex?

G

Guest

When I run a query, which I admit is pretty complex (I didn't write it
myself) I get an error that suggests my expression is either typed
incorrectly or has too many complicated elements.
However, I don't get the error everytime I run the query. The query searches
for exams under a certain score over a given time period. If the time period
includes one particular test date (August 14th) then I get the error. I
removed the exam for that day and the query runs fine. But this exam is
formatted exactly like the others. Any ideas on how I can correct this?
 
G

George Nicholson

I find that I sometimes I get the "too complex" message if I've just edited
a query but haven't saved it. Once I save it, it runs fine.

While 'sometimes' & 'if' isn't very definitive, your situation sounds very
similar.

HTH,
 

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

Expression error 7
Report parameter "too complex" 8
This expression is typed incorrectly, or is too complex 2
"Expression typed incorrectly" 3
This expression is typed incorrectly, or it is to complex to be ev 1
Counting Summary in Reports/Queries 5
Report issues 1
Invalid use of null in query expression 3

Top