Seem to be having trouble with the MAX function
I have a table SHIFT INFORMATION and a field CONTAINER NUMBER, the container number field will vary in sequence.
Here are three examples: I'm looking for the highest number, the example below would yield 4, 30 or 7 respectively.
All fields are number fields or are set to result in a number and contain nothing but numbers.
1 1 1
2 10 3
3 20 5
4 30 7
I created a calculation field using MAX(Container Number) in the same table... I get nothing?
Seems too straight forward for me to screw up?