Expression too complex!?????

[add1023]

Hi. I have a six queries that I am running on different tables. Th
problem is one of my queries started acting weird and was asked for
parameter that I did not tell it to ask for. So I solved that proble
but now every time I try to run the query I get an error message tha
says

"This expression is typed incorrectly or it is too complex to b
evaluated. For example, a numeric expression may contain too man
complicated elements. Try simplifying the expression by assignin
parts of the expression to variables.

However, the parameters are exactly the same as all of the othe
queries and none of those are having problems. I have done som
testing and the query asks 4 question

1. Start Dat
2. End Dat
3. Target or Non Targe
4. Area (user enters 1, 2, 3, or 4

I found that it is the date that is causing the problem. If I remov
that the query runs fine but I really need to have the dates. HEL
please

Thank you in advance

 

[David Seeto via AccessMonster.com]

Um, you're going to have to post some more details for us to have a chance
at debugging this. We'll need the table names & fields, plus the query
definitions, to even begin...

 

[add1023]

Ok. I am very new to access so the problem may be in how the whol
thing is set up. Also, the error message has started coming up o
every query now.

There are 6 tables linked from excel. The tables contain th
following fields..

Month
Start Date
Num
Dir
Street
Complaint
Inspection Date
Comp Date
Target / Non Target
Are

We need to run a parameter query that pulls information based on
range of inspection dates, for those locations in the target, an
choose and area (1, 2, 3, 4). To make it more clear..

Beginning Date: User enters dat
Ending Date: User enters dat
T or N: User enters T for Targe
Area: User enters 1, 2, 3 or

The query has all of the above fields. For Inspection Date criteria
have Between [Beginning Date:] AND [Ending Date:]. Fo
Target/NonTarget, I have [T or N] and for Area I have [1, 2, 3, 4].


This has been working fine without any problems. And then out of th
blue, one of the 6 queries started also asking "Num:" as the las
parameter. After this was fixed, the error message that th
expression was incorrect or too complex began showing up just fo
this table but now it is showing up whenever I try to run any of th
queries.

Does this help at all

 

[add1023]

Nevermind. User error and overlooked the most basic thing. The dat
was being entered in incorrectly.

Thanks anyway! :roll

 

[add1023]

One more thing, the data in the tables are updated daily and sometime
changed. I do not know if this would cause a problem. Thanks