Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Sep 2002
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report by Month (Access 2003)

    I started this report and its getting out of control:

    The Query has Fields: WeeklyUpdate | UpdateWeek (This is a date field MM/DD/YYYY)

    I wanted to show the Month so I can sort the report by month so I used:
    MonthName(Month([UpDate Week]) to get the Months: February, April, etc

    My problem is, how do I create a query for a report.... where the report will sort by Month -- Decending, then by WeeklyUpdate Item.

    Thanks

  2. #2
    3 Star Lounger
    Join Date
    Mar 2006
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    289
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Report by Month (Access 2003)

    Try Format(UpdateWeek,"mmmm") in a new column to get your months sorted decending. Place this column before the WeeklyUpdate column so it sorts first. The use the query for your report.
    Thanks
    chuck

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Report by Month (Access 2003)

    It doesn't matter how you sort in the query, the report will ignore the queries sorting.
    Youdefine the report's sorting in the design view of the report then choose View/Sorting and Grouping.

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

    Re: Report by Month (Access 2003)

    I assume that you want to sort by month chronologically, not alphabetically by name. If you sort on month names, you'd get

    April, August, December, February, January, ...

    if you sort ascending, and the reverse if you sort descending. If you want to sort as

    January, February, March, April, May, ...

    or the reverse, you should use

    TheMonth: Month([UpDateWeek])

    As Patt wrote, you have to specify the sort order for the report in the Sorting and Grouping window in the report design.

Posting Permissions

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