Solved

Microsoft Access

Posted on 2013-06-01
5
218 Views
Last Modified: 2013-06-01
How do I get information from one table to another using query.  Please see attached.
Compliance-Tables.docx
0
Comment
Question by:Student1967
  • 2
  • 2
5 Comments
 
LVL 29

Accepted Solution

by:
IrogSinta earned 250 total points
ID: 39213632
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
 
LVL 70

Expert Comment

by:KCTS
ID: 39213706
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
 

Author Comment

by:Student1967
ID: 39213730
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
 

Author Comment

by:Student1967
ID: 39213740
I figured it out.  I had to make some changes to the update query.  It now works.

Thanks for your help IrogSinta.
0
 
LVL 29

Expert Comment

by:IrogSinta
ID: 39213829
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

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Suggested Solutions

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now