CREATE CURSOR test (Name C(20), Family C(2), Level C(1), Age N(3)) INSERT INTO test VALUES( "", "01", "1", 18) INSERT INTO test VALUES( "", "01", "1", 15) INSERT INTO test VALUES( "", "01", "1", 10) REPLACE ALL Name WITH "Name-" + Family + "-" + Level + "-" + TRANSFORM(Age) * Your query Select Name, Family, Level, Max(Age) Age ; From test ; Group By Family, Level * Data Name Family Level Age Name-01-1-18 01 1 18 Name-01-1-15 01 1 15 Name-01-1-10 01 1 10 * Result Name Family Level Age Name-01-1-10 01 1 18As you can see the 'Name' was pulled from the last physical record in the group not from the record with MAX(age).