Count How Many times a value appears in a table

[younggunnaz69]

I am fairly new in access. I have a table called Projects. In that table, I have every colleague associated with the project and what capacity they acted in. The table looks something like this:

Project Mnger Staff Staff
1 Kim Paul Dave


2 Dave Tom Tom
3 Paul Kim Steve
4 Steve Tom Kim
5 Paul Tom Kim

Im looking for a query that will produce something like this:



Colleague Mnger Staff
Kim 1 3
Dave 1 1
Paul 2 1
Steve 1 1
Tom 0 4

[June7]

Cross post http://forums.aspfree.com/microsoft-...tml#post927577