Query Issue - Error message 3071 (too complex to be evaluated)

[Guest]

Please help this is driving me nuts !!!!

I have set up a query in Access 2003 and for some reason I am getting the
following error 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 have set my parameters and have even
tried to delete other rows within the queries but this seem s to be around
the first two coloumns (Customer name and Customer Location), incidently
these are pulled from another table and are a drop down choice in my main
database. I had used the same query on a single table and this works fine.
The problem has to lie with the fact that I am pulling the data from the
other tables, I have posted a copy of the SQL statement if this help. Any
advice on how to fix this would be very much appreciated. THANK YOU IN
ADVANCE !!!

SELECT [Customer Concerns 2007].[Customer Name], [Customer Concerns
2007].[Customer Location], [Customer Concerns 2007].[Customer Part No (if
Known)], [Customer Concerns 2007].[Stadium Part No], [Customer Concerns
2007].[Part Description], [Customer Concerns 2007].[Problem Description],
[Customer Concerns 2007].ID, [Customer Concerns 2007].[Quantity effected],
[Customer Concerns 2007].[On-Site Support Requested], [Customer Concerns
2007].[8D Status to] FROM [Customer Concerns 2007] WHERE ((([Customer
Concerns 2007].[Customer Name])=[Enter a customer name]) AND (([Customer
Concerns 2007].[Customer Location])=[Enter a customer location]) AND
(([Customer Concerns 2007].[8D Status to])="D1" Or ([Customer Concerns
2007].[8D Status to])="D2" Or ([Customer Concerns 2007].[8D Status to])="D3"
Or ([Customer Concerns 2007].[8D Status to])="D4" Or ([Customer Concerns
2007].[8D Status to])="D5" Or ([Customer Concerns 2007].[8D Status to])="D6"
Or ([Customer Concerns 2007].[8D Status to])="D7"));

 

[Baz]

Can't tell you exactly what is wrong, but I would suggest this for a start:

[Customer Concerns 2007].[8D Status to] BETWEEN "D1" AND "D7"

 

[Gary Walter]

In addition to Baz's sage help,
if the following still gives same error

SELECT
C.[Customer Name],
C.[Customer Location],
C.[Customer Part No (if Known)],
C.[Stadium Part No],
C.[Part Description],
C.[Problem Description],
C.ID,
C.[Quantity effected],
C.[On-Site Support Requested],
C.[8D Status to]
FROM
[Customer Concerns 2007] As C
WHERE
C.[Customer Name]=[Enter a customer name]
AND
C.[Customer Location]=[Enter a customer location]
AND
C.[8D Status to] IN ("D1","D2","D3","D4","D5","D6","D7");

then I might question your use of punctuation
in the field names
-- is "-" in "On-Site.." being mistaken for minus
-- is "(if Known)" being misinterpreted in several ways

quick test (if still getting error) would be to remove
one or both of these fields....

Even if above does run correctly, please think about
changing field names to not include any punctuation
(nor spaces -- use underscore if think you need a space
for readibility)

Special characters that you must avoid when you work with Access databases
http://support.microsoft.com/?id=826763

Please help this is driving me nuts !!!!

I have set up a query in Access 2003 and for some reason I am getting the
following error 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 have set my parameters and have even
tried to delete other rows within the queries but this seem s to be around
the first two coloumns (Customer name and Customer Location), incidently
these are pulled from another table and are a drop down choice in my main
database. I had used the same query on a single table and this works
fine.
The problem has to lie with the fact that I am pulling the data from the
other tables, I have posted a copy of the SQL statement if this help. Any
advice on how to fix this would be very much appreciated. THANK YOU IN
ADVANCE !!!

SELECT [Customer Concerns 2007].[Customer Name], [Customer Concerns
2007].[Customer Location], [Customer Concerns 2007].[Customer Part No (if
Known)], [Customer Concerns 2007].[Stadium Part No], [Customer Concerns
2007].[Part Description], [Customer Concerns 2007].[Problem Description],
[Customer Concerns 2007].ID, [Customer Concerns 2007].[Quantity effected],
[Customer Concerns 2007].[On-Site Support Requested], [Customer Concerns
2007].[8D Status to] FROM [Customer Concerns 2007] WHERE ((([Customer
Concerns 2007].[Customer Name])=[Enter a customer name]) AND (([Customer
Concerns 2007].[Customer Location])=[Enter a customer location]) AND
(([Customer Concerns 2007].[8D Status to])="D1" Or ([Customer Concerns
2007].[8D Status to])="D2" Or ([Customer Concerns 2007].[8D Status
to])="D3"
Or ([Customer Concerns 2007].[8D Status to])="D4" Or ([Customer Concerns
2007].[8D Status to])="D5" Or ([Customer Concerns 2007].[8D Status
to])="D6"
Or ([Customer Concerns 2007].[8D Status to])="D7"));