Data from field in one table to another table

[briank@impactworldtour.co]

I have the following 2 tables:



Table 1:

Partner Number	Name	Donor ID
1234	John Smith
2432	Ed Jones

Imported Table 2:

Partner Number	Donor ID
1234	G5845-425-IR788
2432	K8978-111-PQ007

Table1 has other fields like address, email etc. Table 2 is imported info from Excel. It is a download of donations along with a lookup that gets me the Partner Number.

I want to get the Donor ID from Table2 into the same named field in table1. I would think an update query would be the way to go, but I am not understanding how to make that happen.

[face]

UPDATE Table1 LEFT JOIN Table2 ON Table1.[Partner Number] = Table2.[Partner Number] SET Table1.[Donor ID] = [Table2].[Donor ID];

[JoeM]

Yes, an Update Query is the way to go.
The SQL code would look something like this:

UPDATE Table1 
INNER JOIN Table2 
ON Table1.[Partner Number] = Table2.[Partner Number] 
SET Table1.[Donor ID] = [Table2]![Donor ID]
WHERE Table1.[Donor ID] Is Null;

By adding the WHERE... criteria, it will only look to update records that do not already have a Donor ID in table 1.

[briank@impactworldtour.co]

Worked perfect JoeM. Thank you for your help.