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