Ms Access to calculate the discount rate based on different criteria

[Karthikeyan Devan]

Hi All,

I am not good in MS Access but i need this help very desparately.

I need MS access form with 4 Autofilter option.

Where the first autofilter option will have customer name: XYZ and ZZZ.

Second autofilter option will have Servicve type: Intercity and Metro.

Third auto filter option will have application: Siebel and Oracle.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
Fourth option will have text box for group price where users will enter price.<o></o>
<o> </o>
Fifth option will have text box where it should automatically calculate the discount price based the price which user entered.<o></o>
<o> </o>
Now, the discount part and this is where the twist is:<o></o>
<o> </o>
If user choose XYZ as customer. If it is Intercity in service type and Siebel in application then 50% discount should apply.

If user choose XYZ as customer. If it is Intercity in service type and Oracle in application then 40% discount should apply.

If user choose XYZ as customer. If it is Metro in Service type and Siebel in application then 60% of discount should apply. <o></o>

If user choose XYZ as customer. If it is Metro in service type and Oracle in application then 70% of discount should apply.<o></o>
<o> </o>
<o> </o>


If user choose ZZZ as customer. If it is Intercity in service type and Siebel in application then 40% discount should apply.

If user choose ZZZ as customer. If it is Intercity in service type and Oracle in application then 30% discount should apply.

If user choose ZZZ as customer. If it is Metro in Service type and Siebel in application then 500% of discount should apply.

If user choose ZZZ as customer. If it is Metro in service type and Oracle in application then 80% of discount should apply.



I understand this is little bit confusing but i am not sure how to put this right way. Any help on this would be greatly appreciated.