I have an access database setup as follows:

Field1 Field2 Field3 Field4
John Mike Mike Larry
Steve Danny Mike John


Using vb what is the query to display the data like this:

Position Name How many

1 Mike 3
2 John 2
3 Larry 1
4 Steve 1
5 Danny 1