View original (French)

[access] display month of a date

rodrigue62 Posted messages 201 Status Member -  
Jean_Jacques Posted messages 1045 Registration date   Status Member Last intervention   -
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
  2. 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
  3. 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
      1. fred > Jacques
         
        Hello
        I tried but I get the message

        The input expression contains an invalid period (.), exclamation point (!), or parentheses ().
        0
  4. 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
  7. 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
  8. m4riiine Posted messages 3 Status Member
     
    Hello,

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

    Thank you in advance.
    0
  9. Jean_Jacques Posted messages 1045 Registration date   Status Member Last intervention   112
     
    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