R
Renetta
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.
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.