I have a query. In one of the fields I have this expression…
Expr1: IIf(InStr([FieldName],"(")=0,[ FieldName],Left([FieldName],InStr([FieldName],"(")-1))
Then on the criteria, I have…
Like [Forms]![FormName]![txtFieldName]
But when I run it I get an error “Data type mismatch in criteria expression.”
The FieldName is set to String as data type.
How do I get around this problem. Please help.
Expr1: IIf(InStr([FieldName],"(")=0,[ FieldName],Left([FieldName],InStr([FieldName],"(")-1))
Then on the criteria, I have…
Like [Forms]![FormName]![txtFieldName]
But when I run it I get an error “Data type mismatch in criteria expression.”
The FieldName is set to String as data type.
How do I get around this problem. Please help.