Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    64

    Unanswered: sum in reports and ascending months

    Please, your suggestions is needed


    1. Trying to sum over all using a report exp. =Sum([total]). Only doing part of the report and I did change the running sum to "over all" still I have a problem.

    2. Ascending months like Jan, Feb, and Mar. but it's showing Feb, Jan, and Mar. How can I set the criteria using a query. I will be using this for a report, but the months are not ascending like they should.

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    1. Try putting your textbox control in the report footer

    2. Since you're ordering on the alpha name of the month that is correct. You need to order on the numeric month(1 -12) .. Try using the DatePart function ...

Posting Permissions

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