Question - find highest number in a field out all the records

Kenneth Brody kenbrody at spamcop.net
Wed Aug 22 09:30:58 PDT 2018


On 8/22/2018 11:53 AM, Michael Thompson via Filepro-list wrote:
>   I have a question. How do I get the greatest number in a certain field out of all the records.
> Example: I want pull the 4999 out of all the records to display in field or report.
> 
> rec#   -   Field Value
> 1.      -       1999
> 2.      -       4999
> 3.      -       3999
> 4.      -       2999
> 5.      -       4999
> 6       -       3999

Do a "less than" ("-nl") lookup using the highest possible key value.

-- 
Kenneth Brody


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus



More information about the Filepro-list mailing list