View original (French)

[access] display month of a date

rodrigue62 -  
Hello,
maybe the solution to my problem has already been given, but since I haven't been able to access the forum's search engine for two days, I couldn't find it, so if that's the case, thank you for providing me with the link to the solution.
Actually, I have a report that involves a cross-tab query, and the dates involved all pertain to a specific month since it’s a dialog box that asks me to select the month before running the report. However, I would like to display this month as a title at the top, so I opened a field in which I entered: "=month([DATE])" but the result returned is in numbers (e.g., 1 for January) whereas I want the full name of the month to be displayed, so it shows January and not 1. Is this possible?
I hope I have been clear enough; if not, please feel free to ask for more details, and thank you for your help.

8 answers

  1. Jacques
    Good evening,
    Here is the great secret to obtaining the date in plain text:

    =Format(Date();"Date, complete")

    Sincerely

    Science only finds what has existed since forever.
    Hubert REEVES
    2
    1. Jacques
      Re-good evening,

      Upon re-reading, I believe that:

      ="Month processed: " & Format([DateField];"\ mmmm"" ""yyyy")
      is appropriate for your needs...

      mmmm -> month in its literal form
      yyyy -> year in 4 digits

      That is: May 2006 (for example)

      Best regards
      Science only finds what has always existed.
      Hubert REEVES.
      1
      1. fred
        Hello
        I have an Access query with a date field in the format 11/03/2008
        but I only want to have the month in this field
        thank you for the help
        0
        1. Jacques
          Hello,

          To display the month, the syntax to use is as follows:

          In SQL:

          SELECT Month([<Field_Name_Date>]) AS Month, [<table_name>].[<Field_Name_Date>]) FROM [<table_name>];

          Or (in design mode) on the 'Field' line

          No: Month([<Date_Field>])

          Best regards
          Science only discovers what has existed forever.

          REEVES Hubert.
          0
        2. fred
          @JacquesHello
          I tried but I get the message

          The input expression contains an invalid period (.), exclamation point (!), or parentheses ().
          0
      2. fred
        When I set the value in creation mode on the field, it asks me to enter a parameter value
        <champ_date>
        0
        1. Jacques
          When I set the value in creation mode on the field, it asks me to enter a parameter value
          <champ_date>

          I need to replace the entire string: <champ_date>
          with the name of the field that contains the date to format

          See you +

          Science only discovers what science has always been doing.
          REEVES Hubert.
          0
      4. fred
        It works.

        Thank you for everything.
        0
        1. fred
          Hello
          I have a report in Access and I would like to have a barcode in the report.
          I want to create a receipt with a barcode based on a report.
          Thank you for giving me a hand.
          0
          1. m4riiine
            Hello,

            I would like to group data by month in Access 2007. Can you please help me?

            Thank you in advance.
            0
            1. Jean_Jacques
              Hello m4riiine,

              By adapting the information found at this link, you will be on the right track, I think.

              Follow the link:
              http://www.cijoint.fr/cjlink.php?file=cj201101/cijkH4bqTs.doc

              Sincerely
              --
              Science only discovers what has always existed.
              REEVES Hubert.
              0