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

[Robert Haussmann]

You don't happen to have fpsql do you?  It would be a simple query:

Select max(field_name) from filename

Bob Haussmann

> -----Original Message-----
> From: Filepro-list [mailto:filepro-list-
> bounces+haussma=nextdimension.net at lists.celestial.com] On Behalf Of
> Michael Thompson via Filepro-list
> Sent: Wednesday, August 22, 2018 11:54 AM
> To: filepro-list at lists.celestial.com
> Subject: Question - find highest number in a field out all the records
> 
>  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
> 
> Thanks,
> 
> 
> 
> Michael Thompson, Senior Network Analyst
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://mailman.celestial.com/pipermail/filepro-
> list/attachments/20180822/6a1921b2/attachment.html>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list