Erroe Message when running a query

Payal Patel

Registered User.
Local time
Today, 06:32
Joined
Nov 3, 2009
Messages
34
Hi,
I have a query that runs most of the time but once in awhile I receive this error message- "This expresion is typed incorrectly, or it too complicated 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"
When I try debugging one field at a time, the query does not like the "last name" and "first name" field. I just don't understand because most times it works but sometimes I recieve this error. Does anyone know what the problem could be?

Thanks,
P.
 
Could be NULLS or empty strings causing you pain. Have you written your queries to handle those, if you are referring to them in calculations, formulas, or IIF statements?
 
Are there brackets around the names "last name" and "first name" (i.e., [last name], [first name]. Spaces in field names cause numerous headaches all around. Without the brackets, the query engine probably is confused.
 

Users who are viewing this thread

Back
Top Bottom