SELECT Field1, Count(Field1) as Total_Number
FROM Has_Duplicates
GROUP BY Field1
Output should read:
Test1 3
Test2 2
Test3 2
etc...
(query syntax untested)
HTH
Brian
----- Original Message -----
From: "Joseph Thompson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, June 04, 2001 11:32 PM
Subject: Show Duplicates
> There must be a way to display a list of duplicates from an Access table.
> (going a little batty)
>
> Say I want to display:
> test1 --> 3 occurences
> test2 --> 2 ocurences
>
> TableName: has_duplicates
> Fields:
>
> ID Field1 Field2
> 1 test1 1
> 2 test2 2
> 3 test3 3
> 4 test1 4
> 5 test2 5
> 6 test3 6
> 7 test1 1
>
>
> (Not "important" but... I was a little disturbed that I couldn't figure it
> out)
>
> Thanks for any help :)
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists