>Select * From yourtable Group By soc_sec_num, activate_code, ded_code Having Count(*)>1

Thanks again Edward! That worked perfectly!

Jeff