Custom Query for duplicates 2

[KFuessel]

I have created an Access 2003 database that stores all of our software licenses. With Microsoft Open Licenses, many of the License Agreement Numbers are the same and I would like to list them in a query.

How do I create a Access Query that will list only the records that have duplicate "LicenseAgreementNumber" fields?

Your help will be greatly appreciated.

 

[PHV]

SELECT LicenseAgreementNumber
FROM yourTable
GROUP BY LicenseAgreementNumber
HAVING Count(*)>1

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Pampers]

You could also use the query wizard, one of the options is to create a query that selects duplicate values.

Pampers
Keeping it simple can be complicated

 

[KFuessel]

I tried creating the query again using the query wizard and I did not see the option to "select duplicate values".

I did find the option to omit duplicates by going into Properties for the query and selecting "Yes" for Unique Values, but that is not what I want.

Let me know if I'm looking in the wrong place. Thanks again for your help.

 

[genomon]

Wrong wizard. Click on "New", then highlight "Find Duplicates Query Wizard".

"Before you criticize someone, you should walk a mile in their shoes.
That way, when you criticize them, you're a mile away and you have their shoes."

 

[KFuessel]

It worked perfectly. I did not know that that feature was there.
Thanks again for your help.