There's a wizard for this in Access 2000. On the Queries pane, hit "New"
(oddly not Create query by using wizard), the Find Duplicates Query
Wizard.
Regards,
Matthew Walker
/*
Easier, smarter forms:
http://www.matthewwalker.net.nz/inform2
*/
> -----Original Message-----
> From: Gyrus [mailto:[EMAIL PROTECTED]]
> Sent: Monday, 20 May 2002 10:35 a.m.
> To: CF-Talk
> Subject: SQL: is there such a thing as NOT DISTINCT?
>
>
> 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
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>
______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.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
