M
mohsin via AccessMonster.com
Hi all
I need to develop a matrix table, and at my limited knowledge, i think the
pivot table is the suitable for this database. The problem is to
create/define a queries when two fields is the same as column and row, for
example:
| NE1 | NE2 | NE3 |
----------------------------------------
NE1 | 0 | X | Y |
NE2 | Z | 0 | A |
NE3 | P | J | K |
When NE1=NE1, the queries should put 0, where X,Y,Z is value for matrix
between NE.
Any suggestions, how i can do this?
Thank you and appreciate for your help
I need to develop a matrix table, and at my limited knowledge, i think the
pivot table is the suitable for this database. The problem is to
create/define a queries when two fields is the same as column and row, for
example:
| NE1 | NE2 | NE3 |
----------------------------------------
NE1 | 0 | X | Y |
NE2 | Z | 0 | A |
NE3 | P | J | K |
When NE1=NE1, the queries should put 0, where X,Y,Z is value for matrix
between NE.
Any suggestions, how i can do this?
Thank you and appreciate for your help