I'm trying to find the min and max values in a record for 4 different fields in a query:
[HRC_CenterGrind]
[HRC_CenterSurface]
[HRC_EndSurface1]
[HRC_EndSurface2]
The min and max formulas only allow 2 fields or look for a range of records within the same field.
I found this formula, but I get an error when I update the query that says it's an undefined function:
Highest: FieldMax([HRC_CenterGrind],[HRC_CenterSurface],[HRC_EndSurface1],[HRC_EndSurface2])
I'm ultimately looking for if the difference between the minimum and maximum values in these fields are greater than 4.