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

carrying date into new records

P: n/a
Hi, I am a beginner working on a database to manage clients, payroll,
station assignments, etc. I am having difficulty with sick pay
variables.

I use the following variables;

SickUsed: Sick time used in a given pay period. (Cannot exceed
SickAccumulated) This term is entered by the user

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

SickEarned: If TotalHoursPaid is Less Than 80 then SickEarned Equals
TotalHoursPaid Divided by 20 or if TotalHoursPaid is Greater than or
equal to 80, then SickEarned Equals 4

SickBalance: SickAccumulated Plus SickEarned minus SickUsed (Current
Month)
The Macro: [SickAccumulated]+[SickEarned]-[SickUsed]

Here is what I am trying to do: Each month, the user will enter new
payroll information for each client. Because Sickpay is ongoing, I
would like to have the data automatically transfer when a new payroll
record is entered for a client. What I really need it to do is have
SickBalance become SickAccumulated and be transferred to that field,
when a new record for a client is selected. Can anyone out there help
me with this? If you can please be as detailed as possible in your
response as I am a beginner.

Thank you in advance,
Kgatchell2001
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.