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