Max text calculation
I have ten fields for 10 possible part numbers. I want to display the first part # and have a field to determine the last part number on the page. I used to do this with a Max calculation but now the part numbers have text and can vary in numeric value. I was trying to figure out what calculation to use to display the last part entered on the page. If field 10 is empty then field 9, if field 9 is empty then field 8 and so on.