Res-Com Environmental
relations at rescom.cc
Sun May 22 21:46:20 CDT 2005
I am trying to build a commission system for our sales employees in Access. We are currently using tables for customer, orders, employees, products etc. to link new orders to certain employees, but we want to setup a commission pay system so that employees will receive a certain percentage of each sale based on their number of sales (i.e. if they ge 3-8 sales they get 10%, 8-10 is 13%, 10-12 is 17%, etc., etc. I am relatively new to Access and am wondering if anyone has any advice on how I should start. The system would have to total an employee's weekly sales numbers, produce their percentage commission based upon that, total their sales revenue, and then calculate the total commission they would receive. This may be a simple question, but I've been having a lot of trouble with it. Any help would be greatly appreciated. Sincerely, Adam F