Solved

Microsoft Access

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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

785 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