I have a table that lists the name of the person who did a particular task and I cannot figure out how to list the amount of times the persons name appears numerically. I know how to list all the names, just not how to list them numerically. So for example lets say I have a table called work and inside there's a group called names. SELECT Work.Names FROM Work ORDER BY Work.Names; Using that it will show me how many times in alphabetical order that a name appears inside the table. My goal is to display that numerically, so it will say something like bob - 1 or something of the nature.