Compare Addresses

[qkimchi via AccessMonster.com]

Please Help.

I have two tables that have two fields of addresses. I want to create a query
that can campare the first 5 charecters of these fields only. For example,
1223 Back Street and 1223 Back St. shouldn't be executed because they are
the same. I don't want to go through my table and replace Street with St.

Table 1

 

[Allen Browne]

Create a query with the 2 tables, and no join line between them.

In the Field row, enter:
Left([Table1].[Address1],5)
In the Criteria row under this, enter:
Left([Table2].[Address2],5)