Update Data on a table from another table with new data

[mchadwick]

Table_1_customers
Table_2_MailingList



I have 2 tables, one of them (Table_1_customers) has contact information for all of my customers. It has Name, birthday, address and phone number for data on the table. The other table (Table_2_MailingList) has been updated with new customer information specifically, phone number. Many of the records in the original table have null values for phone numbers. I want to add those phone numbers from table 2 to table 1 without impacting any of the other data. I trust the data in table 1, but not sure about table 2. So, if I dont have any information in a customers record in the phone number field of a record, I want to add it from this record on this table.

Table_1_customers
Field Names
ID, Name, Birthday, Address, PNumber

Table_2_MailingList
Field Names
ID, Name, Birthday, Address, PNumber

[June7]

Run an UPDATE sql action.

You don't show a unique customer ID in either table. How can you be sure the names will match? What if there are two customers named John Smith?

[mchadwick]

I do have an ID field in the hypothetical issue above. I dont know how to do an "Update sql action". what code would I need to write for that to work?

[June7]

Build a query object. Access Help has guidelines on using the query builder.

Is this something will have to do periodically or is this a one-time fix?

[mchadwick]

It's a one time fix, I understand how to create an update query. I'm just not sure on what I need to do to get the criteria of the fields to line up properly

[June7]

What criteria?

Do an INNER JOIN, requires related records in both tables.

Then click UPDATE from the ribbon, under the primary table phone field on the Update To row:

Nz([phone], [linktablename].[phone])

Click Run.

[mchadwick]

Thank you very much, that did the trick. I will for sure use this again for other items.