Auto Calculating in remaining field.

[aligahk06]

Dear All,



Attach file is for ur ref.
I,m having a form with following fields.
Amount,retention and total amount.
i.e the retention and total amount field is dependent on Amount field.
Suppose if i put 10000.00 in Amount field then retention field 10% of Amount automatically calculate and
in total amount field the 90 % of Amount field auto calculate.

Finally Amount Words field auto according to numeric value of total amount field.
Any Help?
e.g

Amount is 10000.00
Retention 1000.00
Total Amponut 9000.00
Text in Amount word fields.Nine thousand only.

Rgds,

Aligahk06

[cementblocks]

Set the control source of the retention field to =[Amount]*.1
Set the control source of the total amount field to =[Amount] * .9

Use the function at http://support.microsoft.com/kb/213360 to convert numbers into words.