How do I make an update query to update fields in one table with fields from another table?

C

Chrisso

Hi All

I have two tables: my main table and a cut-down version of the main
table with newly updated values:

Main
-------
RefNo
Document_Type
Version
Title

ModMain
-------------
RefNo
Document_Type_UPDATED
Version_UPDATED
Title_UPDATED

I cant work how to use Access's query builder to do the simple task of
updating the fields in "Main" with the modified values in "ModMain"
where the RefNos match.

Can anyone give me a pointer or web link? I cant find any information
in Access Help about performing update queries with more than one
table. This seems a straight forward action!

Chrisso
 
G

Guest

In the query designer:
1. Add your 2 tables into the designer
2. join your 2 refno fields together
3.create 3 columns for your updates
Table - Main, Main, Main
Field - Document_Type, Version, Title
Update to: [ModMain].[Document_Type_UPDATED], [ModMain].[Version_UPDATED],
[ModMain].[Title_UPDATED]
Note: you must put the square brackets in otherwise access converts all you
type tp text
 

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

How can I update fields in one table with fields in another table? 3
Update Query to Update Info from One Table to Another 4
Query to update new fields in table 5
copy values from one table to another 3
update multiple fields in a record based on a record in another table 3
sum field from one query to update a field in a table 2
Update certain record fields in one table if data exists in anothe 1
how to update fields in a table 1

Top