There is a "Find Duplicates Query wizard" in Access
In Query, New
just put the SQL inside a cfquery tag
Seamus
At 02:32 pm 5/06/01 , you wrote:
>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