Solved

Query in msaccess

Posted on 2013-11-16
2
382 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 119

Accepted Solution

by:
Rey Obrero 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

920 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

14 Experts available now in Live!

Get 1:1 Help Now