Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    May 2003
    Manchester, Gtr Manchester, England
    Thanked 0 Times in 0 Posts

    Report fields in given order (2000)

    Hi, I have a report that has grouping by a given field, this field only has three entries, for illustration say; Andy, Barry, Carry. Due to the significance of these three entries I need them ordered on the report with Barry first, Andy second and Carry third. As you can see sorting by alpha won't work, how can I have them ordered as required. The report source is a query.

    Thanks Darren.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Report fields in given order (2000)

    Do you have a field that indicates the "significance" of these entries, or from which it could be derived? If not, you could create such a field, and group on that instead of on the name.

    <table border=1><td>Name</td><td>Seq</td><td>Andy</td><td align=center>2</td><td>Barry</td><td align=center>1</td><td>Carry</td><td align=center>3</td></table>
    Depending on the situation, you could create a table like above, and add that to your query.

Posting Permissions

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