SIMPLE ?? Solution

[20leafclover]

Can you help

In this example:

ABC DEF
Num Num Note

101 101 test1
test2
test3

102 102 test1
test2
test3

(1)How can I retrieve ONLY the LAST NOTE for Each Num field.
I want to retireve ONLY: 101 - test3, 102 - test3

 

[dan1967]

Do you have a date field that shows the datetime the record was updated? Do you have a record number that could show the order the records were created? Is there something in the note column value that could be used to show incrementation (did I just make this word up)? If no to all of these, this is a difficult solution.

Dan.