LtCmdrData
Technical User
- Jan 4, 2008
- 11
I have been asked to compile a chart to cross reference all fields within my database of 3 related tables with each other and show a count of how many fields can be matched on the basis that they are not of a null value.
for example
Col_1 Col_2 Col_3 Col_4
abc ABC 1 1
def DEF 2
ghi 3 3
jkl JKL
would look like this ultimatley
Col_1 Col_2 Col_3 Col_4
Col_1 1 3 3 2
Col_2 3 1 2 1
Col_3 3 2 1 2
Col_4 2 1 2 1
I am banging my head against a wall on this one, and to be honest i do not even know if it is possible. Any help at all would be greatly appreciated. I do very much appreciate i have not exactly explained myself very well in this matter but am happy to give it another go.
for example
Col_1 Col_2 Col_3 Col_4
abc ABC 1 1
def DEF 2
ghi 3 3
jkl JKL
would look like this ultimatley
Col_1 Col_2 Col_3 Col_4
Col_1 1 3 3 2
Col_2 3 1 2 1
Col_3 3 2 1 2
Col_4 2 1 2 1
I am banging my head against a wall on this one, and to be honest i do not even know if it is possible. Any help at all would be greatly appreciated. I do very much appreciate i have not exactly explained myself very well in this matter but am happy to give it another go.