Hello. I try to select based on row and column, so only one cell is selected where column and row cross each other. Like an x and y coordinate system where x=columns and y=rows.
Here is an example:
CN1 CN2 CN3
RN1 7 5
RN2 5 3
RN3 9 2
CN means column name and RN row name
"SELECT CN1 AND CN3 FROM [MyTable] WHERE FINDROW = 'RN3'"
Should give me the value 2
But my SELECT statement is not right. I need some help to design it.