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

 

[Mr. B]

The attached database file should do what you are wanting to do.