I would like to return the column names from a linked spreadsheet in Access, where the value is 1 (or greater than zero will do).
Example:
STYLE | VAL1 | VAL2 | VAL3 | VAL4
A_____|______|_ ____|__1___|___ __
B_____|__1___|_ ____|______|__1 __
C_____|______|_ ____|______|___ __
So, Where 'Style' = 'B', return the column name if there is a '1' in it. In this case it would return columns Val1 and Val4.
Example:
STYLE | VAL1 | VAL2 | VAL3 | VAL4
A_____|______|_ ____|__1___|___ __
B_____|__1___|_ ____|______|__1 __
C_____|______|_ ____|______|___ __
So, Where 'Style' = 'B', return the column name if there is a '1' in it. In this case it would return columns Val1 and Val4.