How To Treat Tiered Sales Commissions

[ck01]

I'm working on a contact manager/sales manager database for a company where commission plans are tiered based on the gross margin generated from the sale. The company also has two types of commission plans available to the sales rep (Straight commission & Commission + Base). Here is an example:

I would like to be able to use a table to hold the tiered levels and then use code that would look at the gross margin and determine the correct tier that the sale falls into. Is this possible? If so, can someone please share an example?

Your help will be greatly appreciated and I will definately share the finished project with the group. Thanks!

 

[ck01]

That's great but....

I'll have to give this a try at home tonight. If I have a problem, I hooe you will still be around to help out. ALso, I will definately upload the database for sharing when it is complete. Thanks again!

 

[ck01]

BY the way, if you have an example database, I would ove to see it.

 

[ck01]

I understand. If you don't mind, I would like to try the solution that you offered and if I have problems upload the database to show you. I hope you will still be around to take a look.

Thanks