[AccessD] (no subject)

Break the system down into steps in English. Understand what you want to do
in plain terms first. It will be easier to design after that.

Joe Hecht
Los Angeles CA

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Res-Com
Environmental
Sent: Sunday, May 22, 2005 7:46 PM
To: access at joe2.endjunk.com; accessd at databaseadvisors.com
Subject: [AccessD] (no subject)

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


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com