query

[Guest]

Data Type mismatched in criteria expression error appears. What is wrong
with this query. Please help.

Expr2: IIf(([EData_tbl].[fund]=84),Left([Loan Number],3))

 

[Guest]

Don't know why you're getting a type mismatch - the most obvious thing wrong
is that IIf requires THREE arguments, and you only provide two.

 

[Douglas J. Steele]

In addition to what Ted said, is fund a text field? If it is, you need
quotes around the 84.

 

[Marshall Barton]

Don't know why you're getting a type mismatch - the most obvious thing wrong
is that IIf requires THREE arguments, and you only provide two.

Unlike the VBA function, the IIf function in the expression
service used by the query processor supplies a Null value
for the missing third argument.