Creating Compatibility Matrix

[ChrisBits]

I am interested in creating a form that would display a compatibility matrix. Something like this:


Has anyone every done something similar with access? Any tips?

[Bulzie]

Might need to create query linking those 2 tables, then research creating a Crosstab query off of that query to display on form or report.

[ChrisBits]

Great, thank you. The only complication will be that the table contains a 1 > 2 relationship but not a 2 > 1 relationship (since it would be redundant). But this is pointing me in the right direction, thank you.

[ChrisBits]

Here is the solution to get past the 1 > 2 relationship but not a 2 > 1 relationship issue!!

Create a query of your table, and union the columns together:
SELECT col1, col2, result FROM table
UNION col2, col1, result FROM table

No create your crosstab query based on that query and it will work.

[Bulzie]

So to test I have 2 tables, you link the Animals one in there twice so you can link to each of those Animal columns, that query should show what you have for your martix. Now start a new Query and do the Wizard to create a Crosstab using the above query.