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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
..
 
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
..
 
Back
Top