Unmatched query

[Nick]

I want to build a query that will show me records that do not have a certain
action entry. I want to find all records from "Aoiq" that have do not have an
action number of "07" but have other types of action codes from "01 to "13".
I know it is an unmatched query but am unable to grasp the SQL to make it
work. Please help, I have worked on this for days.

 

[Jeff Boyce]

"How" depends on "what" -- what data and data structure do you have?

For instance, if you have records in a table that holds both "source"
(whatever 'Aoiq' represents) and "action number" (including 07), then you
DON'T need an unmatched query.

If you create a new query in design view, select that table, add those two
fields, and in the 'selection' portion, put "Aoiq" under your "source" field
and "Not '07'" under your "action number", you should get all records with
"Aoiq" and without "07".

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John Spencer]

First step is to build a query that returns all records fro Aoiq that DO have
action number 07.

Next step is to use the unmatched query wizard to build a query based on the
Aoiq table and the above query to find all records that do not have action
number 07.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County