waleed alesayi
New member
- Local time
- Today, 04:47
- Joined
- Aug 27, 2017
- Messages
- 8
I have a program to distribute the amounts according to the duration of the contract Please kindly help when you press the button distribution of the amount in the sub-form, knowing that the amounts are not necessarily equal to the beginning of the contract from 201/7/1/10 until 2017/4/10, The amount will be:
First month of January in the date of 2017/1/10 and in the amount of the amount the following equation is the value of the contract divided by the duration of the contract (3 months) divided by 30 days of the month (on the basis of the month fixed 30 days) multiplied by 20 days to complete the month the amount 2222 .
Second: - The month of February in the date box shall be 2017/2/28 and in the amount of the distribution of the whole month the value of the contract divided by 3 shall be the amount 3333.
Second: - The month of March in the date box will be 2017/3/31 and in the amount of the distribution of the entire month the value of the contract divided by 3 shall be 3333.
Third: The month of April in the date box 2017/4/10 and in the amount of the amount the following equation is the value of the contract divided by the contract period (3 months) divided by 30 days of the month (based on the month fixed 30 days) multiplied by 10 days to complete the month shall be Amount 1111.
This is similar to the premium program, but the distribution of the sum is not equal.
Thank you
First month of January in the date of 2017/1/10 and in the amount of the amount the following equation is the value of the contract divided by the duration of the contract (3 months) divided by 30 days of the month (on the basis of the month fixed 30 days) multiplied by 20 days to complete the month the amount 2222 .
Second: - The month of February in the date box shall be 2017/2/28 and in the amount of the distribution of the whole month the value of the contract divided by 3 shall be the amount 3333.
Second: - The month of March in the date box will be 2017/3/31 and in the amount of the distribution of the entire month the value of the contract divided by 3 shall be 3333.
Third: The month of April in the date box 2017/4/10 and in the amount of the amount the following equation is the value of the contract divided by the contract period (3 months) divided by 30 days of the month (based on the month fixed 30 days) multiplied by 10 days to complete the month shall be Amount 1111.
This is similar to the premium program, but the distribution of the sum is not equal.
Thank you