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------------------------------

markshnier__you · 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
------------------------------

matthardy1 · Answer

So simple. I was over complicating this. Thank you------------------------------Matt Hardy------------------------------

Forum Discussion

Find Highest Field Value

2 Replies