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

    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
    Madison, WI
    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