We help IT Professionals succeed at work.
Get Started

Access 2010 Update querie SQL statement to add more fields.

34 Views
Last Modified: 2016-03-01
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
CERTIFIED EXPERT
Top Expert 2016
Commented:
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE