Making a summary form that will sum the values from another form a

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top