Counting Common Attributes

[Brandon12]

Hello - I am somewhat new to Access, but I have used it to do some pretty cool stuff already. However, a current project has me stumped. I am attempting to count the number of times two separate attributes share a common, separate attribute. Below is an example of the data. How can I count the number of times A & B, A & C, and B & C share the attribute shown in the first column. Thank you!

Attribute	Item
1	A
1	B
1	C
2	A
3	A
3	B
4	A
4	B
5	B
6	A
6	B
7	B
7	C
8	A
8	C
9	C
10	A
10	B
10	C

[aytee111]

Can you post the how the results would look? That would help us understand better what you are trying to achieve.

[Brandon12]

Can you post the how the results would look? That would help us understand better what you are trying to achieve.

Item	Item	In Common
A	B	5
A	C	3
B	A	5
B	C	3
C	A	3
C	B	3

[aytee111]

Table2 is your table name - it is referenced twice. Change it to your table name.

SELECT Table2.Item, Table2_1.Item, Count(Table2.Attribute) AS InCommon
FROM Table2 INNER JOIN Table2 AS Table2_1 ON Table2.[Attribute] = Table2_1.[Attribute]
GROUP BY Table2.Item, Table2_1.Item
HAVING (((Table2_1.Item)<>[table2].[Item]));

[Brandon12]

Thank you very much! Worked like a charm!