Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    London
    Posts
    2

    Unanswered: Access Report Sorted by Month

    I have a report which lists all our employees by their birthday, pretty straight forward, now, I'm trying to get a report that would group them by their month of birth. I'm able to this by the year but I just don't seem to br able to do it by the month. Any ideas?

    Thanks

  2. #2
    Join Date
    Oct 2003
    Location
    US
    Posts
    343

    Re: Access Report Sorted by Month

    SELECT MONTH(BIRTHDATE), Count(EMPLOYEE_NAME)
    FROM TABLE_EMPLOYEE
    GROUP BY MONTH(BIRTHDATE)


    Originally posted by ggrund
    I have a report which lists all our employees by their birthday, pretty straight forward, now, I'm trying to get a report that would group them by their month of birth. I'm able to this by the year but I just don't seem to br able to do it by the month. Any ideas?

    Thanks

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Re: Access Report Sorted by Month

    Originally posted by ggrund
    I have a report which lists all our employees by their birthday, pretty straight forward, now, I'm trying to get a report that would group them by their month of birth. I'm able to this by the year but I just don't seem to br able to do it by the month. Any ideas?

    Thanks
    You can set your Grouping Criteria like here:
    Attached Thumbnails Attached Thumbnails grouping.jpg  

Posting Permissions

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