Help with finding highest value with exceptions
I have a field "Pile Number" that get assigned to Photo Orders. Once we have ten or eleven orders we assign the next higher pile number. The problem I have is knowing how many orders are in the current pile and when to start with the next number. To complicate the problem we have special orders that always get put in pile 99 so I can't just look up the highest value in the field. Any thoughts on how I can let the user know how many orders are in the last assigned pile excluding pile 99?