Jeffrey,

Nadya's code is very complete. Just adding some few lines for checking if identical fields exists before to do anything.

lnQtyRegs = reccount("TableWithDuplicatedRecords") 
select * distinct from TableWithDuplicatedRecords into cursor curDifferentFlds
calculate cnt() to lnQtyDifferent
use
? "DuplicatedRecords = " + allt(str(lnQtyRegs - lnQtyDifferent))

Enrique