Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    300

    Red face Unanswered: Group By Date query

    Its been a while since I did this so I am probably missing something simple...
    I have a query with a date field that I want to group on by month. I thought it was something like Month(Date()) but that returns no records by that grouping. So I tried Month(Date())="1" for January.. etc but that did not work either.

  2. #2
    Join Date
    Jun 2007
    Location
    Maitland NSW,Australia
    Posts
    388
    Use month([field name]) in the field row, in the criteria row put 1 for January or month([field name]) will give you a grouping for each month

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Remember when grouping by months:
    01/01/2005
    01/01/2006
    01/01/2007
    01/01/1954

    All fall under January if you're not careful
    George
    Home | Blog

  4. #4
    Join Date
    Nov 2003
    Posts
    300
    Thank you! That worked. Yes, I will keep that fact in mind about the varying years. For this usage I am using data all within the same year.

Posting Permissions

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