I'm not sure if I can do this.... I'm trying to change the column heading based on the value of another field.
Something like this:
SELECT Other AS 'Other (describe):' + [OtherText]
The value of Other is "X"
The value of OtherText is "Football"
So the column heading would look like: "Other (describe): Football"
The value would be "X"
... I know there are much better ways of doing this, just we don't have the option of changing the table format.
The Select statement would only ever return one single record.