Erroe Message when running a query

[Payal Patel]

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.

 

[boblarson]

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?

 

[kevlray]

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.