Non-Matching Entry Comparison

[smittysahn]

Hi,

I need to compare two Access fields from a county tax roll (real property) and pull out only the fields which have a different address for the property and the homeowner. The problem is that the owner's address is given in the form addresses are normally seen (123 main st....) and the property address is broken up (one field for prefix [N,S,E,W] one field for Street name and one field for suffic (St, PL, et...)but no field for street numbers, thus a direct field comparison searching for unlike symbols is not possible since I can't compare the numbers of the address to any single field.

Is there a way to make this comparison without manually going through every record. Clearly, my knowledge of Access is quite limited and I appreciate any help you can provide.

 

[Brianwarnock]

Comparing addresses in 2 files is a mine field, and in your case without house numbers appears impossible.

I no longer have the code I used when I worked but I used to concatenate all the data into 1 field, replace common words that may be abbreviated by the abbreviations eg Road Street Avenue Saint etc , then Trim out all spaces and compare the resultant strings.

A simple approach that might satisfy your needs would be to just compare on the road name

Brian

 

[smittysahn]

I was thinking there might be a command to ignore numeric values and only compare letter symbols...but nothin like that huh?