AnsweredAssumed Answered

Finding the max value in one field across all records?

Question asked by futurex on Sep 28, 2011
Latest reply on Sep 29, 2011 by futurex

Title

Finding the max value in one field across all records?

Post

This has got to be simple but I can't find it.  I thought Max() would work but that only works on one record or a list of fields.  i want to find the maximum value across all records from one field.

 

It's for invoiceing, I don't want to use a standard serial number because if a record gets deleted then it will skip over a number.  i basically want Max(Invoices::Invoice_Num)+1 but across all records.

Thanks!

Outcomes