Update One Field from Query on Two Tables

[user9]

I have two tables: tblLocal and tblRemote. They both list business demographic formation from separate sources. tblLocal also includes an identification number "ID".

How would I create a query that looks connects the two tables on multiple search criteria and updates the blank "ID" field on tblRemote?

Here are the fields that should match in order to populate tblRemote.ID:

tblLocal.name = tblRemote.business
tblLocal.address = tblRemote.street
tblLocal.city = tblRemote.city

The goal here is to populate the remote table with the identification number. Thank you in advance.

[ItsMe]

You could try to build a query with INNER joins for each of the three fields. Use the query builder. You can choose the Update option from the ribbon. When comparing the two tables there will most likely be slight differences in spelling and or punctuation.