Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Showing Month Names instead of numbers in a report (2000)

    In the Month column on the CONFANNO report in the attached mdb I'd like to show the name of the month instead of its number. How can I do it?
    Attached Files Attached Files

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Showing Month Names instead of numbers in a report (2000)

    Try replacing the following field in query [query1x]:
    pp: Month([qAMDATI.giorno]) & " " & Year([QAMDATI.giorno])

    with

    pp: Format([qAMDATI.giorno],"mmm yyyy")
    This will show the month as 3 chars, if you want the full month use mmmm instead.

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

    Re: Showing Month Names instead of numbers in a report (2000)

    Open the query Query1x in design view, and add a calculated column:

    zz: Format(QAMdati.Giorno,"mmmm yyyy")

    (the column name is arbitrary). Set the control source of the first text box in the Detail section of the report to zz (or whatever name you chose).

Posting Permissions

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