Solved

Access Query

Posted on 2012-03-29
2
276 Views
Last Modified: 2012-03-29
Here is the scenario. I have a local table named tblSVF. the PK is OrderNumber. I have a pass through query and its PK is also OrderNumber. The records in the pass through will always have a corresponding record in the local table. So far so good. here is where it gets tricky. there are times that there will be records in the local table that are not in the pass through. I need to see ALL of the records from both locations only once. I want to accomplish this in one query. this seems like an easy request but for some reason I am having a brain fart and it is easier to ask you pros than to spend a considerable amount of time and do something else until I get it resolved. Thank you everybody. :-)
0
Comment
Question by:JArndt42
2 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
ID: 37784679
Select tblSVF.*, qryPassthru.*
from tblSVF left join qryPassthru
On tblSVF.OrderNumber = qryPassthru.Ordernumber
0
 
LVL 1

Author Closing Comment

by:JArndt42
ID: 37784698
duh! Thanks for releasing the pressure from my brain. :-) a very simple left join from the local table to the pass through shows them all. thanks.
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Suggested Solutions

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

806 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