We need a little more information. You can compute commissions with a
Query, Form or Report. You can store the result in a table, or display or
print it from a Form or Report.
To suggest the best way would require a lot more about the data you
have, the results you need and the current format of the table(s)
We also may want to suggest some table design changes once we know how
they are currently designed.
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.