Hi Nadya,

Having a problem here with your code. The select doesn't fire off and gives me the invalid command error... here's what i have...

FOR i=1 to m.lnFields
IF !INLIST(FIELD(I), "PROJNO", "COMMENTS", "UNIQKEYSAS", "UNIQKEYBAY", ;
"YEAR", "NEWREC", "DISPUTE", "PRO_DATE", "DRAWDATE" )
lcGroupBy=m.lcGroupBy+field(m.i)+iif(m.i=m.lnFields,'',',')
ENDIF
ENDFOR

select *, count(*) as cntDups ;
from tmpdbf ;
group by &lcGroupBy ;
having cntDups>=2 ;
into cursor curDups

isduprec = .t.