if..then

  • Thread starter Thread starter Guest
  • Start date Start date
G

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