Count Field content without counting duplicates

I want to count field contents without counting null and duplicate fields in a report or query for a report using Microsoft Office Access 2003.

Say employee nickname: others dont have others share.