G
Guest
I'm trying to compare two name fields in two different tables. I want the
results to show up in a query. The names in the tables won't be exactly the
same so I thought I would use the Like operator. For example:
Like "*" & "ABCD" & "*"
where Table 1 Name field may have "Company ABCD". Table 2 Name field may
have "ABCD Company". I'm not sure if this expression will work. To
complicate things, I'd really like Access to cycle through each name record
in the two tables and compare them without me having to type in each
individual name. I don't know where I should start or if this is even
possible.
Thanks in advance.
results to show up in a query. The names in the tables won't be exactly the
same so I thought I would use the Like operator. For example:
Like "*" & "ABCD" & "*"
where Table 1 Name field may have "Company ABCD". Table 2 Name field may
have "ABCD Company". I'm not sure if this expression will work. To
complicate things, I'd really like Access to cycle through each name record
in the two tables and compare them without me having to type in each
individual name. I don't know where I should start or if this is even
possible.
Thanks in advance.