Listing then Deleting Duplicates

I have a big table with duplicate entries. I would like to list the unique duplicates onto the screen before deleting them. Then I would like to add a button to the bottom of the screen that allows me to start the dups deleting process. The table has an id column, patient chart number, first name, last name and date of service.

> I have a big table with duplicate entries. I would like to list the > unique duplicates onto the screen before deleting them. Then I would > like to add a button to the bottom of the screen that allows me to > start the dups deleting process. The table has an id column, patient > chart number, first name, last name and date of service. Would you like fries with that?

> unique duplicates ??? ----- Excess quoted text cut - see Original Post for more -----

LoL unique dupes... 1 Select distinct records... 2 Select records that are not in the results from step one. 3 Delete records that are not in the results from step one. Ps.. Don't mind Will... he just has a thing for foods that are bigger than his... ahem... :-p .:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com > Would you like fries with that? > > > >

> Ps.. Don't mind Will... he just has a thing for foods that > are bigger than his... ahem... :-p Wow, you guys must be close to know such intimate details about each other. Now that's agile team development. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information!

Ha! Rick ----- Excess quoted text cut - see Original Post for more -----

...speaking of 'ahems' .:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com > Ps.. Don't mind Will... he just has a thing for foods that > are bigger than his... ahem... :-p Wow, you guys must be close to know such intimate details about each other. Now that's agile team development. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information!