Field in Table 1 references field in Table 2 -- Compare Unused Rec

B

bbarkman

I have a table of numbers (ex. 2100-3100). I have a second table with a
field that accesses the first using a combo box. Not all of the numbers are
used in the second table. Is it possible to query the two tables and find
out which numbers in the first table have not been used by the second table?

Thanks in advance for any help.
 
J

John Spencer

Use the find unmatched query wizard.
New Query: Find Unmatched Query Wizard

That will build a query that would look something like

SELECT FirstTable.NumberField
FROM FirstTable LEFT JOIN SecondTable
ON FirstTable.NumberField = SecondTable.NumberField
WHERE SecondTable.NumberField is Null

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
J

John Spencer

Well, I will say that I have a L O T of puncture wounds. ; < )

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Top