Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Calculate Commission on varialbe rate?
Reading over my post after Golom's reply I realized that I should give more background on this problem. I am trying to explain the problem as simply as possible. I use ODBC to pull the data from a Unix legacy business system. Once I have the tables in Access I am able to query the data to get...- schlorhm
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Calculate Commission on varialbe rate?
Golom thanks for the reply. The amount is calculated by the Invoice amount (InvAmt.). Yes there is a date field that I can use as well as the Invoice Number. The Item doesn't matter because all items will be included in the InvAmt. Thanks in Advance!- schlorhm
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Calculate Commission on varialbe rate?
I am creating a database using Access 2003. I need to calculate a commission on varying percentages. Here is the scenario- When a salesperson sells the first item his commission is 5%, the second 6%, third 7% and fourth or more 8%. I need to count the number of sales for each salesperson then...- schlorhm
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
