AnsweredAssumed Answered

Using ExecuteSQL to Get Max() Matching 2 Groups

Question asked by SimonLiu on Nov 10, 2018
Latest reply on Nov 14, 2018 by beverly

Greeting and appreciation in advance

I have a table like this:

Product 1A1000
Product 2A300
Product 3B200
Product 1B500
Product 1A999


I need to get the highest price for the record matching both Product and Type, and put the results in a new field.


Like this:

Product 1A10001000
Product 2A300300
Product 2B200200
Product 1B500500
Product 1A9991000


I assume that I should make Field4 a calculation using the ExecuteSQL function, however failed after many tries.


Please kindly help me solving this.

Many thanks!