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

  • Thread starter Thread starter Jess
  • Start date Start date
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
 
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!
 
Back
Top