I have two tables in access, with 2 columns in each. Column A and B in table 1. Column C and D in table 2.

I want to compare column A and C, and Column B and D.

I want the results to add a 5th column in the center with some type of match indicator such as:

A B indicator C D

And display the following results:

1. Where both A matches C, and B matches D.

2. Where one of the two matches (A to C) or (B to D)

3. Where neither A and B matches to C and D (respectively)

For #3, it would show blank fields since nothing matches.

Heres an example for 1, 2, and 3:

1. Apple Orange match Apple Orange
2. Apple Grape partial Apple Orange
3. Plum Kiwi none (blank) (blank)

Thanks in advance for any help!