Problems with rounding and accounting

[cddoggett]

I am currently working on a database that keeps track of a series of employee outputs.
i.e. Janie worked on 9/12/2414 failed to contact 413 people regarding their overdue bills, successfully contacted 143, total number = 556, and percentage = x%.
Each employee gets a certain amount of money per person they contact.
i.e. Janie gets 16 cents per person contacted.
There are a series of about 11 or 12 people who work under these same conditions, and their pay goes to the manager of that area, and gets distributed from that point forward.
What I need to be able to do, is per pay period, take the total number of people contacted and pay the management of that department 20 cents per person contacted for every 100, and have the remainder sit at 16 cents per lead.
i.e. if they contact 7414 people in one pay period, the management would get 20 cents per contact for 7400 of them, and 16 cents per contact for 14.
I'm completely lost in how I might go about doing this, any help would be awesome. Thanks =)

 

[SkipVought]

Hi,

Sounds like a homework assignment to me. First one of the semester?

Skip,

_[red][/red]

 

[CautionMP]

cddoggett,
Check out the [tt]Mod[/tt] function, it will help you determine the remainder based on a divisor (i.e. [tt]7414 MOD 100 = 14[/tt]).

Hope this helps,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)

 

[cddoggett]

It's a work thing skip. I wish it were for school, if that were the case, it would be much for fun. As it is right now, I don’t have a deadline, which is good and gives me the chance to research the best possible way of doing this. But I have 1 quarters worth of experience in VB, and that took place about 2 years ago. So I’m sitting here with a billion books in front of me, and all of which are being used to prop up my feet whilst I bang my head against the desk.