I have a table that contains an ID, Name, Class, Date and more fields... The same ID and Name can be repeated more than 1, only the Date are different. For example the same staff can take different classes on different dates as the sample table that's shown below.
ID Name Class DateTaken
1 John SQL 10/30/2014
1 John VBA 07/20/2014
1 John Access 03/10/2014
1 John Excel 12/15/2013
2 Mary Word 09/10/2014
2 Mary Excel 06/25/2014
2 Mary Outlook 04/12/2014
3 Jane Access 08/20/2014
3 Jane Excel 05/15/2014
3 Jane Word 12/15/2013
3 Jane OneNote 09/20/2013
Now, Is it possible to filter itl out, only the "2nd (second) most recent" records, right before the most recent or MAX date, which are highlighted in Green?
e.g.
ID Name Class DateTaken
1 John VBA 07/20/2014
2 Mary Excel 06/25/2014
3 Jane Excel 05/15/2014
Thanks
Phucon
Posted by: saigonf7q5@yahoo.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar