This always works for me:
SELECT po,line, count(po) as test from table group by po, line having test > 1
You may not need the "as" for your db.
Good luck!
Larry
>>> [EMAIL PROTECTED] 06/01/00 10:21AM >>>
Im trying to create a primary key and cannot because I have a few duplicate
entries. The
I'm thinking you'll need to use an aggregate function like this:
HAVING count(po) > 1
AND count(line) > 1
I'm pretty sure the AND can't used like that in a HAVING clause, but you get
the idea.
Jesse D. Roberts
Business Process Analyst
Procurement Quality Assurance
Boeing - Huntingt
--
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.
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:[E
4 matches
Mail list logo