Hi there,
I have two tables with site information. There's a field in each for the site name, with sites from a - z. Unfortunately the site name isn't quite an exact match between tables:
Common_List.Equ ipmentDesc
ADMIRALTY SR, TORPOINT
ALLERS WPS, TIVERTON
BARLEY LANE SR, EXETER
...
SList.SiteDesc
ADMIRALTY SR
ALLERS WPS TIVERTON
BARLEY LANE SR (EXETER)
...
All the strings are of different lengths, have various numbers of words etc. Is there a way to get Access to compare say, the first word of one table with another, and output the matches?
Thanks for you help!
I have two tables with site information. There's a field in each for the site name, with sites from a - z. Unfortunately the site name isn't quite an exact match between tables:
Common_List.Equ ipmentDesc
ADMIRALTY SR, TORPOINT
ALLERS WPS, TIVERTON
BARLEY LANE SR, EXETER
...
SList.SiteDesc
ADMIRALTY SR
ALLERS WPS TIVERTON
BARLEY LANE SR (EXETER)
...
All the strings are of different lengths, have various numbers of words etc. Is there a way to get Access to compare say, the first word of one table with another, and output the matches?
Thanks for you help!
Comment