Find Highest Field Value
I have a table with an Invoice # field (numeric) - how can I find the highest Invoice # using a formula? Thanks ------------------------------ Matt Hardy ------------------------------
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThe 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
------------------------------
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
------------------------------
- So simple. I was over complicating this. Thank you
------------------------------
Matt Hardy
------------------------------
