Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sorting Calculated Fields (A2000)

    I know the capability exists because as usual, I've seen it posted before but didn't have the forethought to record it as a 'good thing'. Situation is that I've produced a report with a calculated field which I would like to rank in descending order. This of course can only be done after the fact. The trick is to SOMEHOW do the calculations, resort the records and then print the report. I would appreciate it if someone could help me with the 'SOMEHOW'. Thanks in advance for your <img src=/S/help.gif border=0 alt=help width=23 height=15>.
    Cheers,
    Andy

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting Calculated Fields (A2000)

    Make the calculation in the query instead of a calculated field in the report.
    Then you can sort on the calculated field of the query
    Francois

  3. #3
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Richland, Washington, USA
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting Calculated Fields (A2000)

    Remember to use Sorting (and Grouping) in the report to get the ordering you want. Specifiying the sort in the underlying query alone won't necessarily give you a sorted report.

  4. #4
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting Calculated Fields (A2000)

    Thanks to you both for the insight. I'm still having a bit of a problem with respect to fact that one of the fields in the report is actually a summing field at a group level, so I've to work through that first. <img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16> I will get back to you kind gentlemen if I'm still stuck. Thanks again.
    Cheers,
    Andy

Posting Permissions

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