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

This help?

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

Yes, thanks very much!

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

The article that Paul pointed to gives you a good explaination of what First() and last() actually return. The Max(), Min(), DMax(), and DMin() functions are more likely to give you the results you are looking for.