M
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
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