Compare Addresses

  • Thread starter Thread starter qkimchi via AccessMonster.com
  • Start date Start date
Q

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
 
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)
 
Back
Top