Update a field from another table via query

  • Thread starter Thread starter Elle via AccessMonster.com
  • Start date Start date
E

Elle via AccessMonster.com

Having issue w/ update query.(Caution I'm a newbie)
I have 2 Tables
1- Emp master which needs the field Dept_Name to be populated
2- Department Master(Field name=D_Name)
The join is for the 2 tables is Dept#
I did a qry Emp master and
field = Dept_name
Table = Emp_Master
Update to= [Department]![D_Name]


I go to view it no data is shown.

Thank you in advance.

Elle
 
When you go to "View it", assuming this means the datasheet view, you won't
"see" anything. When you run the query (!), it will perform the update. If
you need to "view" them first, use a select query to get the idea, then the
update query to perform the operation.
 
Back
Top