Finding the max value in one field across all records?
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.