Everyone,

I have been looking at the Criteria quires and love them so far, except given a set of data like this. I have searched high and low and can not seem to find an example that does this. Thank you in advance.

ID GroupID Value
1 1 Data 1
2 2 Data 2
3 3 Data 3
4 3 Data 3 v1
5 3 Data 3 v2
5 2 Data 2 v1
6 1 Data 1 v1
7 1 Data 1 v2


How with a criteria do I get the most recent edits of this data...ie I want back data that would look like the following.
Data 1 v2
Data 2 v1
Data 3 v2

Thank You
Jim Tyrrell