2 Replies Latest reply on Sep 29, 2011 10:59 AM by futurex

    Finding the max value in one field across all records?

    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!