Comparing Tables in access

[Guest]

I have two tables I am comparing a like field on; which must meet specified
valid criteria from a third table. So, if the field meets the criteria, and
the two fields match then return that value.

I would appreciate any help.

Thanks.

 

[Arvin Meyer [MVP]]

An expression in a query on the tables will work. First run a query or
queries which forces the criteria into a column with the correct data. Then
do your comparison in another column.:

IIf([ColumnA]=[ColumnB], [ColumnC], "")