How do you name an SQL field according to a field value found in a previous query? I am trying to give a descriptive name for a column in an exported file that changes depending on the thing looked up. The first queries get the serial number, test date and date, the second query puts the test data from these queries into different columns for use with Microsoft Chart. I would like to change the names of the columns when they are exported to an Excel spreadsheet to reflect the number and date of the test results in the proper column.
Thanks
Thanks