Query using "Last" doesn't always work, need help on alternative way.

[watsir2]

Hi,

Date sample
Name Date
John 1/2/2009
John 12/1/2008
Mike 1/12/2009
Mike 11/12/2008
Mike 10/2/2007
Jess 1/2/2009
Jess 1/12/2009

When using "Last" in the query, the result:
John 1/2/2009
Mike 11/12/2008 ----> should be 1/12/2009
Jess 1/12/2009

Is there another way writing an expression in the query than "Last"?

Thanks,
Jess

 

[pbaldy]

This help?

http://support.microsoft.com/kb/208190

 

[watsir2]

Yes, thanks very much!

 

[pbaldy]

No problem, and welcome to the site by the way!