Prev: graph on microsoft access
Next: Changing mask on form
From: Tia on 24 May 2010 06:21
what i have is an employee database and i want to apply the following
rules :
Employee Name
Total Package
Total Per Day
Additional days
Total Working Months
Total Working years
Type :Termination/resignation

If the employee is resigning before the completion of 1 year of
service :
He will be getting as benefits total working days -45 days of deduction
+ additional days


If the employee is being terminated before the completion of 6 month
He will get total working days+ additional days


If the employee is being terminated after the completion of 6 month
he will get 1 month salary + additional days
From: golfinray on 24 May 2010 16:14
You need to try working with Datediff. Datediff works like this:
Datediff(["m", [Yourfirstfield],[yoursecondfield])
You can also add or subtract months (the "m" is for months, you can also do
"d" for days)
So Datediff("m",[firstfield],[secondfield] +7)
Experiment with that and see if you get the results you want.
--
Milton Purdy
ACCESS
State of Arkansas


"Tia" wrote:

> what i have is an employee database and i want to apply the following
> rules :
> Employee Name
> Total Package
> Total Per Day
> Additional days
> Total Working Months
> Total Working years
> Type :Termination/resignation
>
> If the employee is resigning before the completion of 1 year of
> service :
> He will be getting as benefits total working days -45 days of deduction
> + additional days
>
>
> If the employee is being terminated before the completion of 6 month
> He will get total working days+ additional days
>
>
> If the employee is being terminated after the completion of 6 month
> he will get 1 month salary + additional days
> .
>
 | 
Pages: 1
Prev: graph on microsoft access
Next: Changing mask on form