Solved

Microsoft Access

Posted on 2013-06-01
5
219 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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This collection of functions covers all the normal rounding methods of just about any numeric value.
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

914 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

17 Experts available now in Live!

Get 1:1 Help Now