Hello,I have a table Tab1:Name Year Value-----------------------John 2010 1000Charles 2008 500Charles 2001 800John 2003 600Mary 2012 2500And need to get the following results:Name Year Value-----------------------Charles 2008 500John 2010 1000Mary 2012 2500As you can see, for each name I need to get the last record of the year.Does anyone know how to get this?Note: using MS-Access.
Thanks.