I am trying to calculate discounted amount in text form. I have Rate Quantity and Total, where i can calculate total amount in text box. Now I want to calculate Discounted amount in another text box after user inputs discount percentage. Any suggestion please
Calculating Discounted amount in Text box
- Thread starter atimsina
- Start date
missinglinq
AWF VIP
- Local time
- Today, 04:43
- Joined
- Jun 20, 2003
- Messages
- 6,420
What expression are you using to do that? It could make a difference in how you do this.
Just to be clear...the amount that has been discounted, i.e. taken off of the total...or the amount due after the discount has been applied?
Linq ;0)>
I want to calculate Discounted amount
My total is calculated with the expression
Private Sub Rate_AfterUpdate()
Me.Total = Me.Quantity * Me.Rate
End Sub
After Rate is updated in Rate text box Total is calculated with above expression.
For Discount I want to update the Discounted amount after discount percentage is given by the user.
Private Sub Discount_AfterUpdate()
Me.Total_Discount = Me.Total - [Total] * [Discount] / 100
End Sub
This expression is working well to calculate discounted amount now but I am not sure if it is right to calculate such fields and store the value in table.
Private Sub Rate_AfterUpdate()
Me.Total = Me.Quantity * Me.Rate
End Sub
After Rate is updated in Rate text box Total is calculated with above expression.
For Discount I want to update the Discounted amount after discount percentage is given by the user.
Private Sub Discount_AfterUpdate()
Me.Total_Discount = Me.Total - [Total] * [Discount] / 100
End Sub
This expression is working well to calculate discounted amount now but I am not sure if it is right to calculate such fields and store the value in table.
