Combine several update queries into one Access 2010

[dhutton27]

Hello,
Have a question about using an update query in Access 2010. I am updating new columns in my database. The two queries below work just fine. How can I combine the two - together so I can run it once instead of having to run each one separate?




UPDATE SalesOrderHeader INNER JOINSalesPerson
ON SalesOrderHeader.SalesPer = SalesPerson.SalesPer
SET SalesOrderHeader.SalesPerID = SalesPerson.SalesPerID;

================================================== ==========

UPDATE SalesOrderHeader INNER JOINJobDesc
ON SalesOrderHeader.JobDesc =JobDesc.JobDesc
SET SalesOrderHeader.JobDescID =JobDesc.JobDescID

[June7]

Can try a query that joins SalesPerson and JobDesc to SalesOrderHeader. Don't use INNER JOIN - use 'Include all records from SalesOrderHeader ...' (LEFT or RIGHT).

Why is this necessary? Why is the descriptive info saved in the first place instead of the ID's? Will this be a regular event or just a one-time edit to fix tables? If it's a one-time event, why the concern about running each individually? Just do it and get it done.

[dhutton27]

Can try a query that joins SalesPerson and JobDesc to SalesOrderHeader. Don't use INNER JOIN - use 'Include all records from SalesOrderHeader ...' (LEFT or RIGHT).

Why is this necessary? Why is the descriptive info saved in the first place instead of the ID's? Will this be a regular event or just a one-time edit to fix tables? If it's a one-time event, why the concern about running each individually? Just do it and get it done.

Yes - your right, could just run it once and be done with it. I have 5 columns to update and thought there might be an easier way and just write one query for all 5. Any way you could give me an example using the 'Include all as you mentioned. Do you mean I can use either a Left or Right Join?

[June7]

Can update as many fields as you want in single UPDATE action. The complication is that the source data is from multiple tables. As long as these are lookup tables should be okay.

Use query builder to first build the SELECT that joins tables then click UPDATE. Click on line that links tables and set the join as described. Result should be LEFT or RIGHT (not sure which one you will end up with).