S
shepherdess
I am making a database that is meant to calculate the commissions for our
salesreps from several sources of income. I have a master form with subforms
for the recording and calculation of sales and maintenance contract
commissions, and would like to add the commission from rentals (in another
table) and bonus and incentives (from another table and entered manually) to
the sales and maintenance contract commissions; then I want to record that
monthly value in a subform that will compare amounts to their goal for the
month and accumulate the ytd data and the goal for that (they get bonus and
incentive for meeting/exceeding their monthy and ytd goals. Can someone help
me plan this out and make it work.
Thanking you in advance for any and all help.
Shepherdess
salesreps from several sources of income. I have a master form with subforms
for the recording and calculation of sales and maintenance contract
commissions, and would like to add the commission from rentals (in another
table) and bonus and incentives (from another table and entered manually) to
the sales and maintenance contract commissions; then I want to record that
monthly value in a subform that will compare amounts to their goal for the
month and accumulate the ytd data and the goal for that (they get bonus and
incentive for meeting/exceeding their monthy and ytd goals. Can someone help
me plan this out and make it work.
Thanking you in advance for any and all help.
Shepherdess