G
Guest
HI, I am having difficulty getting my combo box to format the Value List.
My valkue list is :
26.00;Annual;13.00;Semi-Annual;6.50;Quarterly;4.33;Semi-Monthly;2.16;Monthly;1.00;Fortnightly;0.50;Weekly
The combox box displays the whole part of the number but not the decimal part.
I need the decimal part to be saved so that I can use the data in my report
to convert an amount and then calculate what that amount is per fortnight.
Field1 "Amount"
Field2 "Frequency"
Calculated field "Amount/Frequency"
I have created an unbound field which I would like to store the result, but
the field is only using the whole number which does not calculate the amount
correctly.
As an example, $800 per month is not $400 per fortnight, but $369.23!
Can someone advise how I need to proceed.
Regards
My valkue list is :
26.00;Annual;13.00;Semi-Annual;6.50;Quarterly;4.33;Semi-Monthly;2.16;Monthly;1.00;Fortnightly;0.50;Weekly
The combox box displays the whole part of the number but not the decimal part.
I need the decimal part to be saved so that I can use the data in my report
to convert an amount and then calculate what that amount is per fortnight.
Field1 "Amount"
Field2 "Frequency"
Calculated field "Amount/Frequency"
I have created an unbound field which I would like to store the result, but
the field is only using the whole number which does not calculate the amount
correctly.
As an example, $800 per month is not $400 per fortnight, but $369.23!
Can someone advise how I need to proceed.
Regards