Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003

    Unanswered: Query Column Name, Is this possible?

    Here is my query

    Select iif(month(curdate)=1, JAN, FEB) as x From invoice

    Currently, I have the column named x, is it possible to name it based on the month of curdate? So if the column is populated with January data, I need the column to be name January instead of x.



  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    What are you trying to do here? I get a sneaking suspicion I should be pointing you towards a crosstab query...
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    May 2003
    invoice table contains column Jan, Feb,....., Dec. When I query it, I need to show current month's column first and backward. For example, it's August now so Aug needs to be the first column, then Jul, then Jun......

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts