Sample Data:
ID # Date Balance
3605944 2/15/2012 15:20 $1.19
3605944 2/15/2012 15:20 $2.19
3605944 2/15/2012 15:21 $3.19
3605944 2/15/2012 15:21 $2.94
3605944 2/15/2012 15:21 $2.69 ***
3605972 2/12/2012 9:05 $10.42
3605972 2/13/2012 9:05 $9.42
3605972 2/14/2012 9:05 $8.42 ***
3605981 2/14/2012 10:58 $1.07
3605981 2/14/2012 10:58 $0.82
3605981 2/14/2012 10:58 $0.57
3605981 2/14/2012 10:59 $0.32
3605981 2/14/2012 10:59 $0.07***
How do I sort the data so that only the latest date is left over with it's respective (lowest) balance and card number?
So that I would end up with the data below.
3605944 2/15/2012 15:21 $2.69
3605972 2/14/2012 9:05 $8.42
3605981 2/14/2012 10:59 $0.07
thanks,
Bruce
ID # Date Balance
3605944 2/15/2012 15:20 $1.19
3605944 2/15/2012 15:20 $2.19
3605944 2/15/2012 15:21 $3.19
3605944 2/15/2012 15:21 $2.94
3605944 2/15/2012 15:21 $2.69 ***
3605972 2/12/2012 9:05 $10.42
3605972 2/13/2012 9:05 $9.42
3605972 2/14/2012 9:05 $8.42 ***
3605981 2/14/2012 10:58 $1.07
3605981 2/14/2012 10:58 $0.82
3605981 2/14/2012 10:58 $0.57
3605981 2/14/2012 10:59 $0.32
3605981 2/14/2012 10:59 $0.07***
How do I sort the data so that only the latest date is left over with it's respective (lowest) balance and card number?
So that I would end up with the data below.
3605944 2/15/2012 15:21 $2.69
3605972 2/14/2012 9:05 $8.42
3605981 2/14/2012 10:59 $0.07
thanks,
Bruce