Select rows where there is more than one occurance of a value (opposite of SELECT DISTINCT)

SELECT dbo_tblContributorCA.CCA_Contributor_No, Count(dbo_tblContributorCA.CCA_Contributor_No) AS CountOfCCA_Contributor_No
FROM dbo_tblContributorCA
GROUP BY dbo_tblContributorCA.CCA_Contributor_No
HAVING (((Count(dbo_tblContributorCA.CCA_Contributor_No))>1));