Count the number of times a value appears in a table

[Rob_BTG]

I've read many posts for similar questions, but none apply to my scenario...

I have an Employee Table and a Project Team table that are connected by the Employee ID number.

I want to show how many projects each employee has been on, by counting the number of times each ID appears in the table.

Here is a mock-up of my Project Team table:

Here is what my outpout would look like:

Thanks in advance.

[MFelix · Accepted solution]

Hi @Rob_BTG ,

Believe that the fastest wau would be to unpivot your Project Team Table and stay with only 3 columns Project ID, Team Member, Employee ID then just make a simple count of the number of ID.

Regards,

MFelix

[Rob_BTG]

MFelix,

Thanks, that would be the simplest way.  I was making it harder than it needed to be.