Solved

Query in msaccess

Posted on 2013-11-16
2
397 Views
Last Modified: 2014-02-20
I have a query that returns a list of product numbers.
I have a second query that has a list of product numbers that I want to exclude from the first queries list.
how do I do this?
0
Comment
Question by:PetGuy
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 39653569
create a query like this

select Q1.*
from Q1
left join Q2 on Q1.productnumber=Q2.productnumber
where Q2.productnumber is null




.
0
 
LVL 10

Expert Comment

by:Luke Chung
ID: 39874689
You are looking for a Not-In Query. Here's a paper I wrote with examples of how to do it: http://www.fmsinc.com/MicrosoftAccess/query/outer-join/index.html
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

832 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