Select repeated items

  • Thread starter Thread starter Hendrix10
  • Start date Start date
H

Hendrix10

I'm trying to set up a query where it returns me only the items that
are repeated.

ie...I have a table that has clients that are one time clients and
other that are repeated. Each client has a client number. I would like
to get only the clients whose client number appears more than once. Is
that possible?
 
Yes. The query for this might look something like the following.

SELECT *
FROM TABLE
WHERE ClientNumber in
(SELECT ClientNumber
FROM Table
GROUP BY ClientNumber
HAVING Count(*) > 1

The query wizard (Duplicates) will build the query for you.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Access - Is it possible to repeat fields in a form? 1
Is Access right for what I want to do? 0
relational data base design 3
Concatenate Date and Number field for Append Query 0
table-query-entry form 1
VPN server without domain controller 0
New to Access and need a little help getting started 5
Auto-fill data in Table 2

Back
Top