Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008
    Posts
    27

    Unanswered: List months chronologically on a report

    I have a report, with monthly total for each monthly. How do I get the Month column to display chronologically? So the oldest month is at the top of the page, and the latest month is at the bottom of the page?

    thanks in advance

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    What field type holds your month data?

    If it's a date field, you can sort ascending, descending on the date field.

    Otherwise, you can also use an expression in the recordsource query of the date field: exP: Format([MyDateField],"mm") and then sort that field ascending/deescending.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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