select only those rows that have more than 2 entries based on key field

J

Jess

Hi All,
I have a table that has 2 entries per employee with a few exceptions.
How do I select only those individuals that are the exception? that is,
either <2 or >2 entries?

thanks!
Jess
 
J

Jess

Hey,
I used the find duplicate query wizard and just modified it in SQL view
to say HAVING Count(*)>2 and then modified it and ran it again for
HAVING Count(*)<2.
Works great but I have a hard time with syntax errors in Access when I
try to combine or modify complicated statements...Logically, I can but
syntactically is a pain!
do others have this problem with Access? Does SQL server have the same
problem? ord does it have some help with writing queries.
How did you experts get around this?
thanks!
 
Top