Access Query Criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What criteria would I use to limit my results to include only records that
come up a certain number of times? I'm trying to limit my results to include
records that are in a particular text field at least three times.

Thanks.
 
WOW! Lots of information there.

OK, general example.

SELECT *
FROM YourTable
WHERE SomeField In
(SELECT Somefield
FROM YourTable
GROUP BY SomeField
HAVING Count(SomeField) > 2)

You can use the duplicate query wizard to build a query to find duplicates.
Then take a look at the Having clause in the criteria and replace ">1" with
">2".

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