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 3 Autofilter option, two textbox 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.

Fourth option will have text box for group price where users will enter price.

Fifth option will have text box where it should automatically calculate the discount price based the price which user entered.

Now, the discount part and this is where the twist is:



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.

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




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.

[karthikeyan Devan]

Please help on this issue....