Hi,

Need a help to calculate Text Fields.

My page holds three Text Box Name: Per_Week, MO, Deposit.

I would like to use the method like:

If I enter Per_Week = £100.00

Then in the MO Text Box will show £433.333 (By calculating: 100 * 52 / 12)

At the same time Deposit Box will be £600 (By calculating: 100 * 6)

Note this is Insert Form, the form is working fine, just want save some time to calculate manually.

Hope there is someone who will be able to give me the source of way to understand the code and I hope it help me a lot to do some more experiment.

Looking forward from you.

I am using MS ACCESS + MX + VBScript

Babu

Hi Babu,

can you post the code for your form...i will write the code for you.

Regards

Vince Baker
<strong>DMX Zone Manager</strong>

[VBScript | ASP | HTML | CSS | SQL | Oracle | AS400 | ERP Logic | Hosting]

Hi Vince,

Many many thanks.

Here is my code: I am using Interakt Insert form on that page -

&lt;tr valign="baseline"&gt;
&lt;td align="right" valign="top" nowrap class="BlackBold"&gt;&lt;div align="left"&gt;Per
week: &lt;font color="#FF0000"&gt;*&lt;/font&gt;&lt;/div&gt;&lt;/td&gt;
&lt;td&gt;&lt;input name="Per_week" type="text" class="normal" value="&lt;%=(htmlentities(KT_fakeRs.Fields.Item("Per_week".Value))%&gt;" size="50"&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr valign="baseline"&gt;
&lt;td align="right" valign="top" nowrap class="BlackBold"&gt;&lt;div align="left"&gt;Monthly
Rent: &lt;font color="#FF0000"&gt;*&lt;/font&gt;&lt;/div&gt;&lt;/td&gt;
&lt;td&gt;&lt;input name="MO" type="text" class="normal" value="&lt;%=(htmlentities(KT_fakeRs.Fields.Item("MO".Value))%&gt;" size="50"&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr valign="baseline"&gt;
&lt;td align="right" valign="top" nowrap class="BlackBold"&gt;&lt;div align="left"&gt;Deposit:
&lt;font color="#FF0000"&gt;*&lt;/font&gt; &lt;/div&gt;&lt;/td&gt;
&lt;td&gt;&lt;input name="Deposit" type="text" class="normal" value="&lt;%=(htmlentities(KT_fakeRs.Fields.Item("Deposit".Value))%&gt;" size="50"&gt;&lt;/td&gt;
&lt;/tr&gt;

Hope it will let understand.

Looking forward from you.

Babu

Hi Vince,

Is there any possibility to get the idea?

Please look forward from you.

Babu