Finding unmatched data

[khenry]

Hi

I have two tables. Household and LI. Initially during the application
process these two tables have the same address. But if a user were to change
the address in the household table, the address in the LI table does not
change. I would like to write a query to find what Household addresses no
longer match the LI addresses.

I have pulled down the necessary fields from each table, but can't quite
figure out the criteria of "mismatched addresses".

 

[Jerry Whittle]

Have you tried the Find Unmatched Query Wizard? Depending on the version of
Access go to the database window and click on Queries. Next click on New and
the Find Unmatched Query Wizard should be the last option.

 

[khenry]

I tried the Find Unmatched Query Wizard with no luck. Here are the fields I
have.

Under the Household table

Address 1

Under the LI table

Address

I want the query only to show those Address 1 and Address fields that no
longer match that have a specific application date.

So, if I have an application that shows in Household table Address 1 of PO
Box 98 and in the LI table that Address shows PO Box 26, I want that to show
in the query.

 

[khenry]

I figured it out. I entered in the criteria in the Address 1 field
<>[Address] . This pulled all applicants with mismatched addresses.