Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2002
    Posts
    20

    Wink Unanswered: sorting report details

    Hello,

    I have a working report that has has all the data of a form letter: name, address, and greetings. In the middle of the form details, it lists a number of items I'm shipping with the values:
    [SeriesName] and [CustomOrder]

    both of these items are linked to the form through [OrderID] value. The form works fine now, but it would be great if I could get the report to automatically alphabetize the values of the details by the value [SeriesName].

    Does anybody have a suggestion on how to achieve this?

    Thanks in advance for your assistance!
    Jon

  2. #2
    Join Date
    Nov 2001
    Posts
    336
    Did you try to change the recordsource of the report to

    Select * From tblMyTable Order By SeriesName;

    ?

  3. #3
    Join Date
    Mar 2002
    Posts
    20

    Talking Thanks!

    Worked great! Thanks very much!
    Jon

Posting Permissions

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