Find Highest Field Value

Question

I have a table with an Invoice # field (numeric) - how can I find the highest Invoice # using a formula?Thanks------------------------------Matt Hardy------------------------------

MarkShnierYou · Answer

The easiest way to do this is to make a helper table called Max Invoice with one and only one record in it. The single record will have a Record ID of 1.

The relationship back to your details table and on the reference side make a formula field called Link to Max invoice with a formula of 1.

The summary maximum on that relationship and then look up the maximum invoice number back down to invoices.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community