finding duplicates can't create key field

[Guest]

I imported a list of building telephone jacks and attributes. There seems to
be a duplicate jack somewhere which keeps me from turning this field into a
key field.

Is there an easy way to find the duplicates?

 

[Guest]

Try this SQL in a query to check for duplicates in specific field

SELECT TableName.FieldName, Count(TableName.FieldName) AS CountOfFieldName
FROM TableName
GROUP BY TableName.FieldName
HAVING Count(TableName.FieldName)>1

 

[Guest]

SELECT jacks, count(jacks)
FROM YourTable
GROUP BY jacks
HAVING count(jacks) > 1;

 

[Guest]

This worked good but Access turned it into this:

SELECT Jack.Jack AS Expr1, Count(Jack.Jack) AS Expr2
FROM Jack
GROUP BY Jack.Jack
HAVING (((Count(Jack.Jack))>1));

How do I stick another field ( [Bld Num].Jack ) in here? Everything I've
tried has failed.

 

[Guest]

SELECT Jack.Jack AS Jacks, Jack.[Bld Num] as BldNum,
Count(Jack.Jack) AS JackCount
FROM Jack
GROUP BY Jack.Jack, Jack.[Bld Num]
HAVING (((Count(Jack.Jack))>1));

Try this.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

This worked good but Access turned it into this:

SELECT Jack.Jack AS Expr1, Count(Jack.Jack) AS Expr2
FROM Jack
GROUP BY Jack.Jack
HAVING (((Count(Jack.Jack))>1));

How do I stick another field ( [Bld Num].Jack ) in here? Everything I've
tried has failed.

SELECT jacks, count(jacks)
FROM YourTable
GROUP BY jacks
HAVING count(jacks) > 1;