Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Sydney, New South Wales, Australia
    Posts
    216
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Group by Month Ignoring The Year (2003 SP3)

    How do I create a report grouping by month only irrespective of the year? I just want to see a list of annual building inspections with addresses, contacts etc, to be done January, February, March etc.

    Thanks for all the help.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Group by Month Ignoring The Year (2003 SP3)

    Let's say that you have a date/time field InspectionDate in the record source of the report.
    Open the report in design view.
    Activate the Sorting and Grouping Window.
    Enter the following expression in the Field/Expression column:

    =Month([InspectionDate])

    Set the Group Header, Group Footer etc. properties the way you want.

  3. #3
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Sydney, New South Wales, Australia
    Posts
    216
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Group by Month Ignoring The Year (2003 SP3)

    Thanks. I've attached a sample database because the report is only showing January and June even though the record source clearly has an even spread of months. But I cannot work out why most months are missing. Can anyone see any problems?
    Attached Files Attached Files

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Group by Month Ignoring The Year (2003 SP3)

    Open the report in design view.
    Activate the Sorting and Grouping window.
    Click in the first row, i.e. the one with the expression =Month([BI_InspectionDueDate])
    Set the Group On property to "Each Value".

    (You have set it to group on Month but that is not appropriate here because you're not grouping by a date/time field but by the month number)

  5. #5
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Sydney, New South Wales, Australia
    Posts
    216
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Group by Month Ignoring The Year (2003 SP3)

    Thanks again, Hans. You make it look so easy.

Posting Permissions

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