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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with Access Query! - Merging Rows with Unique ID 0
Max Date in a query whilst showing all fields 4
Have both records from two queries/tables under one Query without related fields. 0
Excel VBA to move cells to sheet2 based on selection in sheet1 0
Adding entried to a table 3
Get rid of "Duplicate Records" in a table 3
Adding Records to a table but preventing duplicates + other tests 7
How to limit Access listbox lookup query using another field 14

Top