Matching information in 2 tables

[chica3578]

Situation:
I currently have 2 tables with the following information-
1) Table_Software (6300 records): Company_Name, Address, City, State, Zip columns
2) Table_Network (13000 records): Company_Name, Address, City, State, Zip, Duns#, SIC, Revenue columns

Issue: Company_Name information has different naming conventions in the 2 tables. Ex: Table_Software has ABC Corporation; Table_Network has ABC Corp. Same issue with address where Rd and Road can exist.

What I need: A list of records from Table_Software where information for its records DOES NOT exist in Table_Network. I want to be able to populate Table_Software with the additional data that exists in Table_Network based on Company_Name, Address, City, State, Zip. If information in Table_Network does not exist, then give me a list of all the records in Table_Software for which I have to find that additional information from a different source.

Please help!!!!!!!!!!!!!!!! Thanks in advance.

-r-

 

[67peshawar294]

chica3578,
How about using the "matched" "unmatched" query? Open "Queries" then "new" and select either matched or unmatched, then follow directions.
jim

 

[chica3578]

I used the unmatched query wizard already. The probles is want to be able to match records based on multiple criteria and not just one as the query does.

 

[MaxEd]

chjica3578,

Can't you use a subquery as the criteria to find what you want?

-Laughter works miracles.