M
Mark Hanson
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"));
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"));