Update field in a table using secon table

[Boss]

I have two tables first table consisit of following fields

Fund
Fundgroup


Second table consist of foll fields

Fund
Purpose 1
Purpose 2

Both the tables are actually different excel sheets which i am planning to
import.

I need to pull fundgroup in second table keeping fund as reference from
first table.

Fund is not a primary key but a fund cannot have two fundgroups.

Please help as this is something very imp for me.

Thanks!
Boss

 

[Dennis]

Create a query by adding table2 and table1 to your design grid and joining on
the Fund field.
Select fields Fund, Purpose1 and Purpose2 from 2nd table and Fundgroup from
1st table. Run the query to check the output.
Change the query type to a make table query and then run again.

 

[Boss]

Dennis,

This was so simple and great.. !!

Thanks for the help..

Boss