simple up-date querry

[planner]

hello all,
i would be extreemly grateful if anyone could offer me some help with this,, basically i have two tables containing the same fields,, one of the table has approx 3k entries where the other has approx 100 entries,, table two (the smaller table) has the same data the only difference being the percentage filed will have increased. for example Tabel 1 has JC111 at 10% and Table 2 has JC111 at 20%,, my life would be made so very much happier if i could find a method of running an up-date query that would take the 'new' % values from table 2 and post them into or create a new table that has the correct/new %'s.
i really hope this makes some sense,, i would appreciate anyones help
best regards

 

[Brianwarnock]

It should be a simple update query
take a copy of Table1 in case this goes pear shaped, then
Join the 2 tables on what ever identifies the rows uniquely.
select the percentage field from table1 and in the update to of the grid put [table2].[percentagefieldname].

Brian

 

[Brianwarnock]

Damn, just discovered that I wasted my time on a double post.