query

R

Renetta

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))
 
T

TedMi

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.
 
D

Douglas J. Steele

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

Marshall Barton

TedMi said:
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.
Click to expand...


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.
 
Top