Sorting data in a query

[martin hopkins]

Hello,

I have a report based on a query that returns employees holiday dates in
descending order.

This works well but new boss only wants to see the last holiday that
staff had. I have tried various methods of trying to return the LAST
HOLIDAY DATE FOR EMPLOYEES but I can not achieve it.

Could anyone help please?

Current query example returns:

Mr Smith 21 Oct 07
Mr A 1 OCT 07
mRS b 28 Sep 07
Mrs b 1 Sep 07
Mr z 29 Aug 07
Mr Smith 28 Aug 07
Mr A 20 Aug 07
Miss Y 1 Aug 07

The new query needs to return:

Mr Smith 21 Oct 07
Mr A 1 OCT 07
mRS b 28 Sep 07
Mr z 29 Aug 07
Miss Y 1 Aug 07

The dates of the last holiday they took.

The data is stored in a holiday table linked to employees by employee
number.

Thanks in advance for any help

Martin Hopkins

 

[Allen Browne]

See:
Getting a related field from a GroupBy (total) query
at:
http://www.mvps.org/access/queries/qry0020.htm

If subqueries are new, here's an introduction:
http://allenbrowne.com/subquery-01.html