Update table based on a field

[fgcity]

Hi everyone

I have 2 Tables

in the first one i have 2 fields

A: 54
B: KKG45

On the second table i have fields with different data but the ID of each field is from 1 - 100 and each field with that ID has an empty field next to it

so i need to update (in this case) Field with an ID "54" (taken from the first table) with the Text KKG45

How do i do that with a Query ?

 

[MStef]

Look at "DemoqueryUPDA2000.mdb" (attachment).
Look at tables, query, run query and see in the table2.

 

[fgcity]

Tnx That really helped.