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