Counting Hits

[Dona]

I've attached a sample of what I'm trying to do. I want to count the number of hits in the column (each number represents only one hit). For example, Bill had a total of 2 hits. Please help me count the hits.

Thank you.

 

[supercharge]

How do you want it accomplished, via a query, form, vba.....?

 

[Dona]

I solved the problem. Attached is the revised sample. I used a group by and expression. I hope this will help someone else. Have a good day!