I have this table i access and when i sort in Usrid the id 1 and 3 have same post selected ( ALFA and Kappa ) i want to list the newest date
that means ID 6 and 11 for Usrid 1 and 8 , 13 for usrid 3 .
ID Usrid Selected Date
1 1 ALFA 2014-01-05
2 2 BETA 2014-01-10
3 3 KAPPA 2014-01-15
4 4 KAPPA 2014-01-20
5 5 ALFA 2014-01-25
6 1 ALFA 2014-01-30
7 2 GAMMA 2014-02-04
8 3 KAPPA 2014-02-09
9 4 ALFA 2014-02-14
10 5 BETA 2014-02-19
11 1 GAMMA 2014-02-24
12 2 KAPPA 2014-03-01
13 3 ALFA 2014-03-06
14 4 BETA 2014-03-11
15 5 GAMMA 2014-03-16
Bookmarks