Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    130

    Unanswered: Report with calcs in Footer

    I have a report with calcs in the footer. When I use
    Me.RecordSource = "qryXYZ", A2K2 seems to ignore the "Order by" component of the SQL (all other statements in the query work properly). When I remove the footer entirely, it sorts properly. There are no Sorting and Grouping statements in the report.

    I would really like to control the sort sequence within the Me.RecordSource statement.

    Anyone seen this problem before? Any ideas on a workaround?
    thanks,
    Winston

  2. #2
    Join Date
    May 2004
    Location
    Moscow, Russia
    Posts
    29
    create autonumber field in query and use this for sorting in group of report

  3. #3
    Join Date
    Apr 2004
    Posts
    130
    That seems a roundabout solution, but will probably work. Do you have any idea why it is ignoring the sort criteria? I understand why if one uses Sorting and Grouping within the report, but it doesn't make sense with just report footer totals etc.
    Winston

Posting Permissions

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