query

[Guest]

OK I wrote this expression (see below), but I get an error - The specified
field ‘[Fund]’ could refer to more than one table listed in the FROM clause
of your SQL statement.

Expr2: IIf(([Fund]=84),Left([Loan Number],3))

The tables I have are Fund_tbl EData_tbl and Fund 84_tbl - all tables have
Fund in it, but I want it to ref. the EData_tbl. How do I work this into the
expression.

 

[Duane Hookom]

Try:
AMoreDescriptiveTitle: IIf((EData_tbl.[Fund]=84),Left([Loan
Number],3),"whatever if not")

 

[Guest]

I get a Data type mismatched criteria expression

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

Try:
AMoreDescriptiveTitle: IIf((EData_tbl.[Fund]=84),Left([Loan
Number],3),"whatever if not")

--
Duane Hookom
MS Access MVP

OK I wrote this expression (see below), but I get an error - The specified
field '[Fund]' could refer to more than one table listed in the FROM
clause
of your SQL statement.

Expr2: IIf(([Fund]=84),Left([Loan Number],3))

The tables I have are Fund_tbl EData_tbl and Fund 84_tbl - all tables have
Fund in it, but I want it to ref. the EData_tbl. How do I work this into
the
expression.