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

  • Thread starter Thread starter Chrisso
  • Start date Start date
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
 
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
 
Back
Top