>I thank all in advance for any help. I have been asked to provide a screen lookup, or browse window where the user would like to filter and show only the records where a specific field has duplicates. Is it possible to do in an SQL, or do I have to write a function to extract the duplicates first, then simply browse those?
Hi Carmen,
If you want only display duplicates than
SELECT * FROM mytable ;
WHERE KeyField1 IN ( ;
SELECT KeyField1 FROM mytable GROUP BY 1 HAVING COUNT(*) > 1 ) ;
INTO CURSOR crsDups
--sb--