How do I use access queries to select records which appears 3 time

A

Aviador380

Hello,

I have set up a database to record staff sickness, and I would like to
create a query that pulls out records where the staff member has 3 or more
occurences i.e. a query that retrevies records where the staff member appears
3 times.

How do I do it?

Many Thanks
Paul
 
T

Tom Ellison

Dear Paul:

Build a "totals query" that counts how many instances you have for each
staff member. Filter it for >= 3.

Tom Ellison
 
D

Dann

SELECT SDays.Name, Count(SDays.Name) AS CountOfName
FROM SDays
GROUP BY SDays.Name
HAVING (((Count(SDays.Name))>=3));
 
Top