Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Posts
    56

    Unanswered: Problems with Report

    I have a report based on a select query. Within the query there is a "start date" and an "end date". I have sorted the start date to ascending. When I run the qury it executes it correctly with the start date in ascending order with the other data correctly shown.

    However, when I preview the report, it shows the answers unsorted, ir the date is not sorted in ascending order. Any ideas why this should be the case?

    Thanks col_bol

  2. #2
    Join Date
    May 2004
    Posts
    73
    In design mode of the report, go to the report>OrderBy property then enter "FieldName ASC" or DESC. Hope that helps.
    Last edited by X-Centric; 10-25-04 at 15:55.

Posting Permissions

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