Greetings Experts,
I have a Access DB where I store sales data from our CRM server.
I base this DB for all my Excel calculations/reports via MS Query.
Now I have the business requirement to calculate the monthly commission for each sales advisor.
It is based on a chart as per business rules and I have promptly placed these in an Access table as well.
Now I have the sales table, commission chart table and some other useful lookup tables.
Once I have a query that provides the correct commission calculation along with the entire sales field table, I can transfer this over to Excel for a 'subtotal' and my work is done.
How do I calculate the commission based on this chart in Access Query?
I have attached all the relevant tables and lookup tables for this exercise.
Kindly advise how to go about this to obtain the desired results.
Warm Regards,
Philip