D
Don
I apologize if I've used the wrong section.
I am working on a query that will calculate commissions for my salespeople.
Instead of creating a long formula in the query to calculate the result (the
percentage of commission each salesperson earns is directly tied to the
amount of profit each salesperson generates; therefore the commission rate
can change), I would like to have a table populated with different commission
rates that will be used in a shorter formula in my query.
Example: If a salesperson generates over 30% profit, he will earn 10% of the
profit; if he generates over 20% profit, he will earn 7.5% profit; if he
generates over 10% profit, he will earn 5% profit.
Can I have a formula in my query that will calculate the query field
"Profit_Percent" and then find the appropriate commission percentage in the
table? Can this be performed if a salesperson's "Profit_Percent" is a number
that is not in the table, such as 23.4%?
If this can be done, can someone show me the way this would be written so
that I can understand the thought process.
If I have not been clear in my rambling here, please ask me to be clearer in
my explanation; I've got to figure this out. Thanks...
I am working on a query that will calculate commissions for my salespeople.
Instead of creating a long formula in the query to calculate the result (the
percentage of commission each salesperson earns is directly tied to the
amount of profit each salesperson generates; therefore the commission rate
can change), I would like to have a table populated with different commission
rates that will be used in a shorter formula in my query.
Example: If a salesperson generates over 30% profit, he will earn 10% of the
profit; if he generates over 20% profit, he will earn 7.5% profit; if he
generates over 10% profit, he will earn 5% profit.
Can I have a formula in my query that will calculate the query field
"Profit_Percent" and then find the appropriate commission percentage in the
table? Can this be performed if a salesperson's "Profit_Percent" is a number
that is not in the table, such as 23.4%?
If this can be done, can someone show me the way this would be written so
that I can understand the thought process.
If I have not been clear in my rambling here, please ask me to be clearer in
my explanation; I've got to figure this out. Thanks...