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

[Guest]

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

 

[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

 

[Guest]

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