How do I compare two tables?

[Nancy]

I'm trying to compare the value of a field in one table to the value in a
field in a seconday table. The comparision field is a alpha field.

 

[Clifford Bass]

Hi Nancy,

More specifics would help, such as how do you associate the rows from
the one table to the rows in the second table? And what kind of comparison?
What are the specific table and field names? Try something like this:

select A.Field1, A.Field2, B.Field1, B.Field2, "They are " & IIf(B.Field2 =
A.Field2, "", "not ") & "equal" As TheComparison
from A inner join B on B.Field1 = A.Field1;

If that does not help, post the specifics.

Clifford Bass