Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2002
    Location
    Oakland, CA
    Posts
    126

    Unanswered: Display text from a number

    I know how to create a number from a month but what is the reverse function? If I have 2, how do I turn it into February. If I have 4 into April? Thanks for the help

  2. #2
    Join Date
    Oct 2002
    Location
    NSW Australia
    Posts
    61
    Try:
    format([yourNumberHere],"mmm")

  3. #3
    Join Date
    Nov 2002
    Location
    Oakland, CA
    Posts
    126
    I tried that and I keep getting January, no matter what the value is.... Any other thoughts?

  4. #4
    Join Date
    Nov 2002
    Location
    San Francisco
    Posts
    251
    you have to stick there dummy day and year....

    format(myMonth & "/01/2002","mmmm")



    jiri

  5. #5
    Join Date
    Nov 2002
    Location
    Oakland, CA
    Posts
    126
    Yes, that works, I want to take it one step further (it's actually just a tweak). I've attached a jpg of the criteria (red underline) that I'm using. The -1 in it gives me all data for the previous month. Now I have a problem, obviously when the month is January. January - 1 doesn't give me December. I've tried iff statement that I couldn't fully implement, so perhaps some of you will have a solution... Thanks in advance
    Attached Thumbnails Attached Thumbnails dbcriteriainquery.jpg  

Posting Permissions

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