if..then

[Guest]

Table A Field A
HO
WA

Table B Field B Field C
HO Hollister
WA Watsonville

desired expression:
take the value in TableA FieldA, look for that value(match?) in
TableBFieldB, then return the value in TableBFieldC

 

[Duane Hookom]

That's what queries are for. You add table B to a query with Table A and
join FieldA with FieldB. You can then display fieldC in your query, form, or
report.

 

[Guest]

Thanks, That works.