To answer the last post, the data is contained in one table and here are the queries in question.
The query that only evaluates duplicates and contains 5278 records is as follows:
SELECT DISTINCTROW First(POTbl.POComboID) AS [POComboID Field], Count(POTbl.POComboID) AS NumberOfDups
FROM POTbl
GROUP BY POTbl.POComboID
HAVING (((Count(POTbl.POComboID))>1));
The query that has additional (necessary) fields and contains fewer records (5241) is:
SELECT DISTINCTROW First(POTbl.POComboID) AS [POComboID Field], Count(POTbl.POComboID) AS NumberOfDups, POTbl.Ord_No, POTbl.Line_No, POTbl.Vend_No, POTbl.Item_No, POTbl.Item_Desc_1, POTbl.Item_Desc_2
FROM POTbl
GROUP BY POTbl.Ord_No, POTbl.Line_No, POTbl.Vend_No, POTbl.Item_No, POTbl.Item_Desc_1, POTbl.Item_Desc_2,POTbl.POComboID
HAVING (((Count(POTbl.POComboID))>1));
Thanx, Jim