Dynamic Column Names or Column Alias

• jwmadison

  Old Hand

  Points: 345

  More actions

  September 3, 2002 at 9:31 am

  #79375

  Is it possible for column names or aliases to be generated dynamically?

  I have a query that will return monthly totals for a range of 12 months, but the start month can vary. Instead of using 'Month1', 'Month2', etc. it would be nice for the column headings to show 'mmyyyy'. I tried using local variables, but it did not work.

• jwmadison

  Old Hand

  Points: 345

  More actions

  September 3, 2002 at 1:45 pm

  #435875

  Thank you Stuart, this is a big help.