Chintsapete
Registered User.
- Local time
- Today, 09:36
- Joined
- Jun 15, 2012
- Messages
- 137
Hi all
I need to calculate a 3 years cycle for sick leave from Date of engagement. I tried with DateAdd and DateDiff, but somehow got stuck. How do I get to start the cycle over? Is there a way to do that in a query?
I have a table Salaries YTD where all the data is collected. I'm trying to do a query. I have so far a query called SickPrep:
SCStart: DateOfEngagment
SCEnd: DateAdd("m",36,[DateOfEngagment])
I made another query called SickLeave where I re-query the above:
Restart: DateAdd("m",36,[SCEnd])
But how can I get that to loop indefinite? I'm completely stuck with this and can't seem to find a solution.
Anyone's got an idea?
Thanks
Pete
I need to calculate a 3 years cycle for sick leave from Date of engagement. I tried with DateAdd and DateDiff, but somehow got stuck. How do I get to start the cycle over? Is there a way to do that in a query?
I have a table Salaries YTD where all the data is collected. I'm trying to do a query. I have so far a query called SickPrep:
SCStart: DateOfEngagment
SCEnd: DateAdd("m",36,[DateOfEngagment])
I made another query called SickLeave where I re-query the above:
Restart: DateAdd("m",36,[SCEnd])
But how can I get that to loop indefinite? I'm completely stuck with this and can't seem to find a solution.
Anyone's got an idea?
Thanks
Pete