Damon, Just use standard SQL with GROUP BY and HAVING:
SELECT invnum, COUNT (*) FROM tablename GROUP BY invnum HAVING COUNT (*) > 1 Bill On Wed, Mar 4, 2009 at 2:33 PM, Gray, Damon <[email protected]> wrote: > I’m trying to find duplicate invoice numbers in a table and am looking > for an “is not unique” or “where not unique” type function in 6.5++. Am I > missing it, or does it just not exist? > > > > wwwww > > ( @ @ ) > > -------oOO---(_)---OOo------- > > Damon J. Gray > > Anvil Corporation Business Services > > (360) 937-0770 > > oooo0 0oooo > > ( ) ( ) > > ----------\ (----) /----------- > > \__) (__/ > > >
