Re: Expression too complex?
- From: "George Nicholson" <GeorgeNJunk@xxxxxxxxxxx>
- Date: Thu, 23 Aug 2007 13:02:47 -0500
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,
"Julius_Council" <JuliusCouncil@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AAA8065A-5F1E-4A20-8A68-6DF2B732D37E@xxxxxxxxxxxxxxxx
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?
.
- Prev by Date: Re: How can I put dictionary-style page headers in an Access report?
- Next by Date: Re: Counting Number of Min/Max Instances
- Previous by thread: Re: How can I put dictionary-style page headers in an Access report?
- Next by thread: Re: IIF statement
- Index(es):
Relevant Pages
|
