Results 1 to 2 of 2
  1. #1
    Alex Motilal is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Nov 2008
    Location
    Coimbatore, India
    Posts
    192

    Grouping By Month, Year

    I have created a report for the period from October 2018 to March 2019 based on the dates of several records. Grouping is done on Month, Year, for example December, 2018. On the sorting the report shows February, 2019 before January, 2019. I think it may be because of alphabetical order.


    Is there a way to solve this.

    Alex

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    create a calculated value in your query that provides the correct numerical order e.g.

    sortby:format(myDate,"yymm")

    then use that in your report to sort. It does not have to be displayed in the report

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 07-13-2015, 02:06 PM
  2. age and day - month - year
    By azhar2006 in forum Access
    Replies: 4
    Last Post: 08-21-2014, 08:30 AM
  3. Replies: 4
    Last Post: 05-26-2013, 03:28 PM
  4. Grouping by Month in Report
    By ccordner in forum Reports
    Replies: 2
    Last Post: 12-20-2011, 09:05 AM
  5. by year by month
    By nkuebelbeck in forum Reports
    Replies: 21
    Last Post: 03-24-2010, 01:53 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums