Update a field from another table via query

  • Thread starter Elle via AccessMonster.com
  • 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
 
M

[MVP] S.Clark

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update query. Within the same table: populating field 2 from field 6
Querying from the same table 2
Selectively Update Field in Table 2
Query to update table with data from another 2
Editing a query with 2 joined tables 1
Update the values in a table from another table 1
Modifying a field in one table with data from another table 2
extra field for a table as Text from table qry ? 5

Top