Update one table with data from another Table

[altrotx]

I have one table with 2 fields and 1700 records



PartNum PartNotes

Another Table with 36 fields and 8000 records the PartNum and PartNotes fields are common to both.

I have tried every way to join the 2 tables and update the 2nd table with the data from the 1st table against the correct PartNum in table 2 using an update query.

I'm very new to access and sql so this is a very steep learning curve for me. (Old time Paradox user)

Cheers

[maximus]

I have one table with 2 fields and 1700 records

PartNum PartNotes

Another Table with 36 fields and 8000 records the PartNum and PartNotes fields are common to both.

I have tried every way to join the 2 tables and update the 2nd table with the data from the 1st table against the correct PartNum in table 2 using an update query.

I'm very new to access and sql so this is a very steep learning curve for me. (Old time Paradox user)

Cheers

I will try to demonstrate with a simple set here:

I have two tables Table4 with Fields:
1) xxy (Number Primary Key)
2) yyx (Text)

Table5:
1) xxy (Number Primary Key)
2) yyx (Text)
3) ABC (Text)

My goal here is to update Table5 Field yyx where Feild xxy are same in both the tables. The SQL will be as below:

UPDATE Table4 INNER JOIN Table5 ON Table4.xxy = Table5.xxy SET Table5.yyx = [Table4].[yyx];