Re: Sort file by computed field

From: Robert Wagner (robert.deletethis_at_wagner.net)
Date: 06/13/04 

Date: Sun, 13 Jun 2004 10:19:13 GMT

Sally Pascoe <sallypascoe@hotmail.com> wrote:

>I want to sort records for a report in descending order of a computed
>field.
>
>How do I sort records in a file based on a computed field based on two
>fields in that file but the computed field is not in the file?
>
>Even a keyword for the command so I had something to look for would be
>a help.

You use the SORT verb. The INPUT PROCEDURE computes the sort key, which is in
the SD file. The OUTPUT PROCEDURE prints the report.

Relevant Pages

  • Re: Sort file by computed field
    ... You say that you are to sort on a computed field that is not in the ... would appear as the first record of the output file along with all the ... something like all between one value and the next group minus one. ...
    (comp.lang.cobol)
  • Re: Sort file by computed field
    ... > How do I sort records in a file based on a computed field based on two ... Seeing that this is a COBOL newsgroup - how about using a COBOL sort? ...
    (comp.lang.cobol)
  • Re: Sorting Months
    ... Add a computed field that returns the month number (either the Month ... function, or format as mm, not m). ... Sort on that field, even if you don't ... > instead of by calendar order. ...
    (microsoft.public.access.reports)
  • Re: Sort Ascending
    ... Easiest solution would be to add a computed field to the query, and sort on ... there are some entries that do not have any dates. ... ascending sort. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Sort by Month
    ... Add a computed field to your query, and sort by it. ... > format of dd/mm/yy. ...
    (microsoft.public.access.queries)