Calculation of Sales Commission

[Nur Muhammad]

Dear Friend:
I want to create a database, which report me montly sales commission like
the bellow:
Dear Friend:
I want to pay sales commission using the following system:
Designation Consolidated Salary Primary Target Rate per BDT 100,000
Target Fulfillment Non-Fulfillment
Trainee Sales 10,000 2,000,000 BDT 375 BDT 330
Sales Executive12,000 2,500,000 BDT 390
BDT 375
Senior Sales Executive15,000 3,500,000 BDT 420
BDT 390

So, if any sales person like Sales Executive sales Tk, 4,000,000 then his
commission will be 4,000,000/100000*390=Tk. 15600.
And Another sales person like, Senior Sales Executive sales Tk. 3,000,0000
then his commission will be 3,000,000/1000000*390= Tk. 11700
Pls help me who I can use this system using access

If you give a complete access demo file I will please

Thanks
Nur Muhammad
(e-mail address removed)

 

[Ryan]

This could easily be done in a query. Put all your fields in the query, then
add

Tk[Primary Target]/1,000,000)*[BDT]

In database design make BDT, Salesperson Type its own table, and salesperson
seperate tables with relationships. That way in your query you will be able
to have different BDT's for each salesperson.