By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,451 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 IT Pros & Developers. It's quick & easy.

Carrying payroll data into new records

P: n/a
Hello,

I am using Access 2002 to track payroll. I am trying to carry a
person's Sick time accrued into the next record for an individual. I
am a beginner with access.

I am using the following terms:

SickUsed: Sick time used in a given pay period. (Cannot exceed
SickAccumulated)

SickAccumulated: SickAccumulated through previous month minus SickUsed
(A person can only use sick time accumulated through previous
payperiod)

SickEarned: TotalHours Divided by 79.9 or if TotalHours is greater
than or equal to 80, then SickEarned is 4

SickBalance: SickAccumulated Plus SickEarned minus SickUsed (Current
Month)

Here is my main question: I want the SickBalance from the current
record to become SickAccumulated when a new payroll record is entered
for a person. Is there a way to make Access do this?

Thank you,

Kgatchell2001
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
This is possible but not for the light heated. To do this, you need to
setup a field that is a counter, but the counter cannot miss any. To
complex things further, you will need have the counter reset for each
employe. For example:
Employee 1 Rec 1
Employee 1 Rec 2
Employee 1 Rec 3
Employee 1 Rec 4

Employee 2 Rec 1
Employee 2 Rec 2
Employee 2 Rec 3
Employee 2 Rec 4

There is no built-in function to do this. This can be accomplished via
VBA. Since you are wanting to store the results, your balance forward
calculation all use domain aggregate functions. Would not take me long to
do though.

You might look at doing this on a query. Group on employee, sum the
accrued column, sum the usage column, Accrued - Used, and so on.

--
Dean Covey
www.coveyaccounting.com

"kgatchell2001" <kg***********@yahoo.com> wrote in message
news:b2**************************@posting.google.c om...
Hello,

I am using Access 2002 to track payroll. I am trying to carry a
person's Sick time accrued into the next record for an individual. I
am a beginner with access.

I am using the following terms:

SickUsed: Sick time used in a given pay period. (Cannot exceed
SickAccumulated)

SickAccumulated: SickAccumulated through previous month minus SickUsed
(A person can only use sick time accumulated through previous
payperiod)

SickEarned: TotalHours Divided by 79.9 or if TotalHours is greater
than or equal to 80, then SickEarned is 4

SickBalance: SickAccumulated Plus SickEarned minus SickUsed (Current
Month)

Here is my main question: I want the SickBalance from the current
record to become SickAccumulated when a new payroll record is entered
for a person. Is there a way to make Access do this?

Thank you,

Kgatchell2001

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.