Unsure where this needs to be

[Joe C]

Sorry if I am in the wrong forum but I need direction on this one report.

I have a need to automaticallu enter data on regular basis. Every month an
employee earns sick and vacation time. I need that to be listed in the table
thus the report. I have too many employees to do that manually.

Any suggestions?

Joe
Papi

 

[Klatuu]

I would have put this in Modulesdaovba, but that is okay.

This can be done either with an action query or in VBA, depending on how
comples the business rules are.

Before you even open Access to start, you need to document the business
rules regarding the vaction and sick time.

You need to know how may days of each are accumulated each month. In many
cases, vaction time accrured will depend on longevity. Sick days are usually
more static, but you need to know the rules to apply the values.

How you implement it will aslo depend on how your time keeping system works.
Not only do you have to accrure the time, you also have to record that it
has been used.

There is also the issue of year end rollover. What and how much carries over?