P
Pete
YearsService: DateDiff("yyyy",
[DateOfCommencement],DateSerial(Year(Date()),12,31))
I use the above statement in a query to calculate the length of time
an Employee has been employed, I then filter this to look for those
with 25 or 35 years service.
How could I then amend this to look ahead for the next 3 years e.g
2007,2008,2009 and see how many employees qulaify for Long Service in
the forthcoming years
Thanks in advance
Peter
[DateOfCommencement],DateSerial(Year(Date()),12,31))
I use the above statement in a query to calculate the length of time
an Employee has been employed, I then filter this to look for those
with 25 or 35 years service.
How could I then amend this to look ahead for the next 3 years e.g
2007,2008,2009 and see how many employees qulaify for Long Service in
the forthcoming years
Thanks in advance
Peter