Hello, I have a table with a list of dentists and which carrier's networks they are in. I want to produce a grid that will show a count of which ones each carrier has in common. The table has the following four fields; ID, Last Name, First Name & Carrier (see attached example). How do I set up the query to produce a grid like the one below:
Carrier A Carrier B Carrier C Carrier D
Carrier A N/A 3 2 4
Carrier B 3 N/A 4 4
Carrier C 2 4 N/A 3
Carrier D 4 4 3 N/A
I tried a crosstab, but it is not quite getting me what I need. It shows the names along the rows, but then I have to look by hand to see where the name is in more than one carrier in the column.
Carrier A Carrier B Carrier C Carrier D
Carrier A N/A 3 2 4
Carrier B 3 N/A 4 4
Carrier C 2 4 N/A 3
Carrier D 4 4 3 N/A
I tried a crosstab, but it is not quite getting me what I need. It shows the names along the rows, but then I have to look by hand to see where the name is in more than one carrier in the column.
