Microsoft Access

How do I get information from one table to another using query.  Please see attached.
Compliance-Tables.docx
Student1967Asked:
Who is Participating?
 
IrogSintaConnect With a Mentor Commented:
You need to use an Update query instead.
UPDATE ComplianceImport T1 INNER JOIN ComplianceBOTable T2 ON T1.[Loan Number] = T2.[Loan Number] SET T1.[Borrower Last Name] = T2.[Borrower Last Name], T1.[Borrower First Name] = T2.[Borrower First Name]

Open in new window

0
 
Brian PiercePhotographerCommented:
You either need to use a MakeTable query (to create a new table), or an Append query if you want to add to a table that already exists.
0
 
Student1967Author Commented:
I tried the update query and it didn't work.  What did I do wrong?  I updated my document to show the screen prints of the queries I did.
Compliance-Tables.docx
0
 
Student1967Author Commented:
I figured it out.  I had to make some changes to the update query.  It now works.

Thanks for your help IrogSinta.
0
 
IrogSintaCommented:
Looking at your screenshots, it looks like you didn't use my query as I gave it to you. It would have worked if you had inserted it in the SQL view of your query design.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.