This is a duplicate query created using Access2000, hope this will help you!
SELECT First([categoryName]) AS [categoryName Field], Count([categoryName])
AS NumberOfDups
FROM Category
GROUP BY [categoryName]
HAVING Count([categoryName])>1;
-----Original Message-----
From: Adrian Cesana [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 01, 2000 11:22 AM
To: [EMAIL PROTECTED]
Subject: query help - find duplicates
Im trying to create a primary key and cannot because I have a few duplicate
entries. There should not be any so I am trying to find them. The key
consists of 2 fields(po,line), Im trying to run a query that will only
display the duplicates, this is what Im trying.
SELECT po,line from table where po = po AND line = line
how can I change this so it only display's the duplicate entries?
-Adrian
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
