Updating specific fields in table 1 with fields from table 2

[vickan240sx]

Hi,



I have 2 tables.

Table 1: Master table
Table 2: Temporary table

This is my current process:

1. Every quarter I run a report that pulls loans that meet specific criteria.
2. I export this report into excel (the loans fall into column A)
3. I add a file number and box number in columns B and C.
4. I import the excel spreadsheet to table 2 (they're linked so I don't need to import, it's automatic)

Now that I have the updated information back into the database (table 2), how can I get this information back into table 1? The excel spreadsheet only contains a few loans that need to be updated in table 1. I have tried creating an update query with both tables linked and use the "update to" field. However, when I tried to run the query, it says I have 0 records updated.

My update query is as follows:

Field: Access Bar Code
Table: Table 1
Update To: [Table 2].[Access Bar Code]

Field: Access Box Number
Table: Table 1
Update To: [Table 2].[Access Box Number]

Basically I'm trying to have the query update specific fields in table 1 based on the information from table 2.

[vickan240sx]

I solved my own problem. I didn't link the correct fields from table 1 to table 2. I had to link the loan number as they are both unique fields located on both tables.