bitbucket-25253

I will definitely look into this to get a better understanding.

Thanks for the reply!

Eureka! I Found it.

I created a temp table and Inner Joined it to produce the desired results.

SELECT CID,

COUNT(CID) AS NumOccurrences

Into tblCID FROM tblContacts

GROUP BY CID

HAVING (COUNT(CID) > 2)

order by...

Thanks for the reply,

When I paste your query it works perfectly, but when I change it to apply to one of my existing tables NumOccurrences always = 1 even if...