>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?
>
>Thanks.
>Carmen
Carmen,
In addition to Sergey's reply there is a file in Downloads section here called DupCheck. The author notified, what he released a new version of it recently...
If it's not broken, fix it until it is.
My Blog