One way to isolate these "not distinct" rows would be something like this: SELECT myColumn, count(myColumn) FROM myTable WHERE count(myColumn) > 1
This would give you only return rows where where there was more than one instance. HTH, Stephen > I want to output all records in a table where a certain field is > duplicated at least once. My first instinct is to filter in the SQL > - but how?! I'm using Access 2000, and the field in question is > VARCHAR. > > DISTINCT doesn't *seem* to support being negated with NOT, and > anyway, isn't it only meant for numeric fields? > > Will I have to run some complex CF code to rebuild the query once > it's returned? > > Confused! Any help welcomed... > > - Gyrus > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > - [EMAIL PROTECTED] > work: http://www.tengai.co.uk > play: http://www.norlonto.net > - PGP key available > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists