Inverting Columns and Rows in Query

[jlclark4]

I created a "Involved" table that has a list of name in it as column headers. Each field is set to Yes/No.

I used this table as a subform in a ticketing system to track all those who are involved in each ticket.

I want to be able to report how many tickets a user is involved in. Is that possible? I am okay with the long way... See example data below

tblInvolved
Ticket_ID
Client_ID
Employee_1
Employee_2
Employee_3
Employee_4
Employee_5

11 2 True False False False True
14 3 False True False True True
15 3 False True True False False
17 1 True True False False True

I want a query to provide me:
Employee True False
Employee_1 2 2
Employee_2 3 1
Employee_3 1 3
Employee_4 1 3
Employee_5 3 1

[rzw0wr]

I am not sure of all you are asking.

However, look at the Dcount() function in a query.

Dale