Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Sep 2006
    Posts
    166
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Months query (Access 2000)

    In my query the number of the months is shown with figures for example 1 for january etc. Can i convert these numbers into words, say january instead of 1 ?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Months query (Access 2000)

    I assume that you have a date field in your query, and a calculated column looking like

    M: Month([DateField])

    For display purposes, use the date field itself and set its Format property to mmm if you want the abbreviated name such as Jan, Feb etc., or to mmmm for the complete name such as January, February. You can also create a new column based on the date field.

  3. #3
    2 Star Lounger
    Join Date
    Sep 2006
    Posts
    166
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Months query (Access 2000)

    Thanks. is it possible to do the formating not in the date field itself but in the report ?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Months query (Access 2000)

    Yes: place a text box bound to the date field on the report, and set the Format property of the text box to mmm or mmmm.

  5. #5
    2 Star Lounger
    Join Date
    Sep 2006
    Posts
    166
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Months query (Access 2000)

    Thanks. If i put in the Format propert mmm or mmmm or the months are named January. Why is it so ?

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Months query (Access 2000)

    Sorry, I don't understand. Did you mean "all" the months are named January?

  7. #7
    2 Star Lounger
    Join Date
    Sep 2006
    Posts
    166
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Months query (Access 2000)

    yes, all the months. But the same result is seen also in the totals query if i put xxx in the Format property. .Is it possibl to write Format in the control ?

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Months query (Access 2000)

    What is the field you are trying this on? It should NOT be a field defined as Month([InvoiceDate]) or something like that, but the date field itself.

    You could try

    Format([InvoiceDate], "mmm")

    in the query, or

    =Format([InvoiceDate], "mmm")

    on the report.

Posting Permissions

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