I tried the following code and got back 3823873 records.  It is as if the code didn't do anything.  I am wondering if I should have First in this code somewhere?? select * from TEMP_PAYMENT_1 t1 inner join (select DSCNMBR, ICASSUF, ICASTYPE, MSACOMP, DCSPOL, DCSCERT, min(DCSADD) as MinDCSADD from TEMP_PAYMENT_1 group by DSCNMBR, ICASSUF, ICASTYPE, MSACOMP, DCSPOL, DCSCERT) t2 on t1.DSCNMBR = t2.DSCNMBR and t1.ICASSUF = t2.ICASSUF and t1.ICASTYPE = t2.ICASTYPE and t1.MSACOMP = t2.MSACOMP and t1.DCSPOL = t2.DCSPOL and t1.DCSCERT = t2.DCSCERT ... View more

It does have more columns than listed in the BY statement.  There are 22 columns.  I "think" that duplicates are ok in DCSADD.  The reason that I know the proposed SQL isn't working right is because I know how many records I am supposed to be getting back, 717843.  The original data set is 3823873, then after the SQL code it should be 717843. ... View more

Thank you both for your suggestions.  I am still having trouble with this.  I am wanting to re-write this code in MS Access SQL.  ... View more

If you *HAD* to replicate it, what would you do? ... View more