I have 5 tables which all have a unique key that is relative to each. I would like to write a query that I can then create a Venn Diagram upon that shows the overlap of each:


-------| table1 | table2 | table3 | table4 | table5
table1 | 100 | 25 | 30 | 25 | 33
table2 | 25 | 200 | 45 | 67 | 87
table3 | 30 | 45 | 120 | 88 | 12
table4 | 25 | 67 | 88 | 189 | 99
table5 | 33 | 87 | 12 | 99 | 333

Any ideas? (Besides writing a ton of queries)

Also... has anyone ever heard of someone developing a Venn component for Access? I use a CRM tool called SmartFOCUS Viper which has a Venn GUI and does what I'm requesting above. However, it's quite a task to make their proprietary db for such a small job. In the tool you can actually use CTRL and highlight the venn intersections to drag and save/build your queries.

Thanks!
Doug