Deductions in a report

[gscma1]

I have a database that deals with employees and holds there details.

Is it possible for the database to work out how many holidays a worker has accrued? at a rate of 1.67days per month.

Obviously the holidays a worker accrues in one year are for the next year. Therefore workers have holidays accrued for the current year and each time they take one i want it to deduct from this value.

Any advise on how to do this?

Many Thanks in advance

 

[dhookom]

How do we know where "each time they take one" can be retrieved from? Also, is "1.67days per month" always the same for every employee no matter which position or how many years they have worked for the company?

Are we to assume that a worker can't take any vacation for the first year?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[gscma1]

I have a seperate table which links an employee with number of days they wish to take as holiday and the reasons etc. therefore this is filled in "each time they take one"

Currently 1.67 days is the accrual rate, as the employees this applies to are relatively new.

a worker can take holidays whenever they want however, to take a paid holiday they must have accrued it prior to taking it.

It is possible for a new employee to have worked for one month and accrued 1.67 days and to have a paid holiday for 1 day the following month. however we do not advise this, it is wiser for a worker to have accrued all there holidays before taking them paid.

 

[gscma1]

Can anyone assist with this?

 

[dhookom]

Please provide more complete details on your table structures. We have heard there is a database and "a separate table" but don't know where you might be storing hire date, hours worked, hours taken, accrual rate, rules about when employees can begin taking paid holidays,...

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[gscma1]

I have one table - tblEmployees, which holds all employee details, I have a seperate table which holds details of the hours worked - tblHours, each week hours are entered against an employee id.

Holidays are input seperately, in tblHolidays, days holiday being taken and reason why against an employee id.

Now that is as far as I've got, I am unsure what to do with the accrual system. i did think to put a field in tblemployees, to show the amount of holidays an employee has accrued, however this would involve a lot of manual input and regular checking and updating.

The rule is an employee can take a holiday as long as they have accrued it. the rate of accrual as said previously is 1.67 days each month.

 

[dhookom]

I was expecting to see some actual field names of significant fields rather than "holds all employee details".

This is kinda like asking us to build you a table from your materials and according to your specifications. When I asked what "materials" you have to work with, the answer is some boards and screws. Your specifications are getting a little clearer but we still haven't seen your table structures or sample records.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]