Hello:
I have 2 different tables from 2 different entities and I am trying to combine the data. The common field in both tables is Address.
The problem is that the addresses come from different places and many of them do not mach exactly. For example one table may be Main St and the other may be Main Street
If I do a one-one relationship an query where both address field are alike, I get about 20,000 of 50,000
records returned, which is a good start.
I have not used access since version 2000 and used to be ok, but I found I have forgotten almost everything. Would Excel be better suited for this?
Thanks in advance for your help.
Mark