Finding the highest value of 8 fields

[Jim McDonald]

I have 8 different fields set up in a database, and need to create a new field that uses the highest value of these eight.

Can anybody tell me a nifty way to calculate this value?

Thanks in advance.

[Chuck]

FileMaker has a built-in function to handle this called Max.

Max( field1, field2, field3, field4, field5, field6, field7, field8 )

will return the maximum value from those eight fields.

Chuck