Select latest record from query

[mh579]

Hello,

I have a query that returns employess details and lists the dates that they have taken holidays. All is find but I wish to use the same query but restrict the return values to only include the last holiday date taken that is nearest to the system date eg today.

This I believe will give me a single list with for example:

Emp Last Hols

Mr Smith 12 Sep 07
Mrs Block 6 Jun 07

etc

Thanks in advance

Martin Hopkins