Updating a Table with Data from Another Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table of Job Codes as follows:
Job Code Job Family Number

The Job Code field is populated, but the Job Family Number field is
currently empty. I want to add a value to the Job Family Number field based
on the Job Code field by looking at another table that has these values in
them.

The other table also has the fields Job Code and Job Family Number.

In Excel I would do this through a lookup table.

Any help is greatly appreciated.
 
Have you tried building a query linking the tables and showing the field to
be updated using the query wizard, then using the option to change that
query to be an update query?
 
You must log in or register to reply here.

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

Multiple Table Search 15
Calculation in a query 2
Migrate mailboxes from one Microsoft Exchange Server to another Exchange 2
Two Table Query 4
Queries across tables, merging/concatenating 0
update a sequence of records to seperate fields in new table 7
Query to work out which rate should be inserted 2
Update Two Tables Using One Form Contents 0

Back
Top