Hi all, i use ud4, and i have a repeated field with numbers, and text (example field, Name, money), and i would like to do the summ of the repeated field money, how can i do that??Thanx

hey, I don't know if there's an ultradev solution to this, but I do know that the answer you seek can be easily coded...
1. find the piece of code that spits out the result of the money field
(ie. &lt;%=recordset1.fields("theMoney"%&gt<img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>

2. turn that, into this:
&lt;%
total = total + recordset1.fields("theMoney"
%&gt;

3. then find the end of the loop, this will usually be a "wend" or a "loop" keyword, and add this <b>After</b> the loop is finished:

&lt;%=formatCurrency(total)%&gt;


of course you will have to account for formatting (ie. make sure it's not between table rows), and that should take care of you.

Joel Martinez [ ]
----------
E-Commerce Concepts with Ultradev...pre-order yours at
www.basic-ultradev.com/ecomm_concepts/

Other solution is to create Query/View that will calculate summ.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
hey, I don't know if there's an ultradev solution to this, but I do know that the answer you seek can be easily coded...
1. find the piece of code that spits out the result of the money field
(ie. &lt;%=recordset1.fields("theMoney"%&gt<img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>

2. turn that, into this:
&lt;%
total = total + recordset1.fields("theMoney"
%&gt;

3. then find the end of the loop, this will usually be a "wend" or a "loop" keyword, and add this <b>After</b> the loop is finished:

&lt;%=formatCurrency(total)%&gt;


of course you will have to account for formatting (ie. make sure it's not between table rows), and that should take care of you.

Joel Martinez [ ]
----------
E-Commerce Concepts with Ultradev...pre-order yours at
www.basic-ultradev.com/ecomm_concepts/
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

I need a little input on this issue.

I have used the <pre id=code><font face=courier size=2 id=code> &lt;%
subtotal = subtotal + recordset1.field("theMoney"
%&gt;</font id=code></pre id=code> to get the total of repeat region and what I am trying to do is add the sum of the repeat region and a coulmn for another recordedset. I have used the following but it fails when I try this.
<pre id=code><font face=courier size=2 id=code> &lt;%GrandTotal = subtotal + OrderDetailsRS.fields("shipping"%&gt;
</font id=code></pre id=code>
Can some one help with this? Is there somthing that I am missing?


Edited by - redbaran on 07 Feb 2004 00:30:54