comparing first characters of 2 columns

[ESteveP]

Hi,

Please, can someone give me some advice or point me in the right direction.
I have a table that has many columns but 2 are address columns
the addresses are similar in both columns except for abbreviations.
IE. 42 Jones Road vs. 42 Jones Rd

I am trying to isolate these by setting up a query that would match lets say
the first seven characters of each column, if they are different, display
them in the query.

Can anyone, Please offer any help. It would be greatly appreciated.

Steve

 

[Allen Browne]

Type a calculated field into the Field row of your query, e.g.:
Left([Address1], 7)
In the Criteria row under this field:
Left([Address2], 7)

Replace Address1 and Address2 with the names of your fields.

 

[Kelvin]

Another option is just to set the criteria for one of the address to <> the
other address. This will check the entire field. For example, if your
fields are Add1 and Add2, set the criteria for Add1 to "<> [Add2]" withou
the quotation marks.

Kelvin