Hoping to create a field that will look at 9 specific fields, determine the largest number, and put it into the field.
Look at the Max() function.
You can use it either in a Calculation field, or as an Auto-Enter calculation for a field.
Sounds like a homework problem.
Nine different fields walk into a bar, the bartender, Max, says ...
On a serious note, I wonder why you have nine different fields (data points) to evaluate. Are they all in the same table? As an FYI, the Max function also works with related data ... e.g. Max ( RelatedTable::dataPointValue )
basically the 9 fields are scores for each record and i want a field that will tell me the high score without looking
At least it's not an eigenvector problem with a 5x5!
The Max ( field1; field2; etc. ) will work for you as you require. (Max(repeating field) will also work.)
However, many of the experts here would suggest that your data model is wonky in that you should have a separate table for your nine scores, related to a parent record.
It's not a simple improvement/solution; but if your tables get very large, you should consider it.
Retrieving data ...