Access 2010 Update querie SQL statement to add more fields.

get-ADuser -F ($_.Name -eq "Todd")
get-ADuser -F ($_.Name -eq "Todd") used Ask the Experts™
on
Hello,  I am updating a "Computers" table from and "UpdateLap" table.  I found the SQL statement needed to update 1 field at a time, but could use some help to add more fields to the statement.  I currently am using:

UPDATE UpdateLap INNER JOIN Computers ON UpdateLap.Users = Computers.Users SET Computers.Memory = [UpdateLap].[Memory];


I would like to add fields from "UpdateLap" to the "Computers" table.  the fields would be like

Computers.Description = UpdateLap.Description.   And Computers.[Machine Type] = UpdateLap.[MA Type].  And so on.  I am not sure of the syntax to add more fields.  Any help would certainly help with time, instead of doing each one individually.  

Your help is very much appreciated.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016
Commented:
just separate each field with comma

UPDATE UpdateLap INNER JOIN Computers ON UpdateLap.Users = Computers.Users
SET Computers.Memory = [UpdateLap].[Memory]
,Computers.Description = UpdateLap.Description
,Computers.[Machine Type] = UpdateLap.[MA Type]

Author

Commented:
I knew I was damn close!!  Thanks much!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial