Comparing tables

[Guest]

I have two tables that I am comparing on a particular field. Then I have a
third table that has valid criteria for the first two tables. Here's my
issue: I want the first two tables which I'm comparing to look at the third
table to make sure the criteria is valid, if it is then return that value.

Thanks.

 

[John W. Vinson]

I have two tables that I am comparing on a particular field. Then I have a
third table that has valid criteria for the first two tables. Here's my
issue: I want the first two tables which I'm comparing to look at the third
table to make sure the criteria is valid, if it is then return that value.

Thanks.

I'm not sure I understand. "That value"????

Could you post a more specific description of the tables, what comparison
you're doing, what criteria you're searching, and what value you want
returned?

John W. Vinson [MVP]