I am trying to get a MAX and several fields in a query so thought I could use:

result: Max(Array([CM=PM],[CM=PM w/inc],[CM>0 & PM=0],[CM/STD],[CM<PM & PM<>0]))

But it doesn't like that - I get a message that says:

You tried to execute a query that doesn't include the specified expression "combine" as part of the aggregate funtion.

Any suggestions or help is greatly appreciated!