BBK
Registered User.
- Local time
- Today, 00:18
- Joined
- Jul 19, 2010
- Messages
- 71
I have 3 input fields:
- RentAmount ( Currency, entered by user )
- PaymentFrequency ( Drop down selection which is either Weekly or Monthly )
- MonthlyAmountDue ( Currency, calculated )
I would like to be able to have the 'MonthlyAmountDue' textbox automatically display the total Rent Amount.
The problem i have is:
If PaymentFrequency is weekly then i need to multiply the 'RentAmount by 4' and display this result then in the 'MonthlyAmountDue' textbox
If PaymentFrequency is monthly then do nothing and just display this result in the 'MonthlyAmountDue' textbox.
Stupid as this is, i dont know how to go about doing it, or how to know if the PaymentFrequency is Monthly or Weekly so wether or not to multiply by 4 or not.
Any help or advice would be greatly appreciated.
Thanks for reading

- RentAmount ( Currency, entered by user )
- PaymentFrequency ( Drop down selection which is either Weekly or Monthly )
- MonthlyAmountDue ( Currency, calculated )
I would like to be able to have the 'MonthlyAmountDue' textbox automatically display the total Rent Amount.
The problem i have is:
If PaymentFrequency is weekly then i need to multiply the 'RentAmount by 4' and display this result then in the 'MonthlyAmountDue' textbox
If PaymentFrequency is monthly then do nothing and just display this result in the 'MonthlyAmountDue' textbox.
Stupid as this is, i dont know how to go about doing it, or how to know if the PaymentFrequency is Monthly or Weekly so wether or not to multiply by 4 or not.
Any help or advice would be greatly appreciated.
Thanks for reading
