Kamis, 30 Oktober 2014

[MS_AccessPros] Filtering Dates

 

 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