It is as follows:
We have a from with 4 fields(layout elements) eg., Item1, Item2, Item3 & Item 4, all numerical or money fileds.  The program in Item3 is: Item3 = Item1*Item2. Then we want a grand total of all the figures in the Item3 fields accross the forms added together and placed  in the Item4.  I think QA didnot have this facility.  Help is requested. 
This user form is doing a fantastic job in clearing all the doubts.  Thank you.
Mathew Verghese

Let me see if I can make myself clear: (1 form and 4 layout elements)
first entry- 20.00x10.00 = 200.00(press F10)
second -    10.00x5.00   =  50.00 (press F10)
third entry-15.00 x 10.00=150.00(F10)
when the above is being done what we get in the Item4 field is 200.00 next 250.00, next 400.00 and so on. what I require is the programming for the Item4 field

Mathew Verghese

Quote:


Do you need the running total only for the records you are currently entering, or do you need a running total for all the records in the database?

Just set up one more field as Counter, which is a number field.  Sesame gives you capability to setup multple counters which advance by one using Globalvalue () command that was thoroughly discussed earlier.  
[url]http://www.lantica.com/Forum2/cgi-bin/yabb/YaBB.pl?board=gen_disc;action=display;num=1073429412;start=6[/url]

Use the code like

If @IsNew and item4 = "" then
  {
           item4 = @xlookup (@filename, counter -   1, "counter", "item4") + item3
    }

You might have to use massupdate to get the initial value. If you want to have this periodic total set the value of item3 to 0 as certain time breaks like end of the year or end of the month.

You can also use @number to set up counter but you can have only one @number per ?application or may be database (not sure).

I used this technique with Q&A.

Thinking further, the above code will work fine with mass update (ofcouse you have to remove If @isnew conditon), however, the way @number counter and I believe also counter created by globalvalue ( ) command, you might have to modify it a little bit.

If you open up form to add record and decide to exit it, the @number code will have already advanced the counter and there is no mechanism in place to reset it if you decide all of sudden to escape  and not save the record.  When you back to add new record the previous value in the counter would not coincide with any value.

One can solve this problem in more than one ways, just modify the code that it will read the record previous record the highest counter value.

If @IsNew and item4 = "" then 
   {
           item4 = @xlookupr (@filename, 99999999999, "counter", "item4") + item3
     }

There is other way you can accomplish this by using loop in subtracting 1 each time until it does not result in error.  That is ..... if @error ... condition. 

I am not upto the speed with loops quite yet.

Thank you Alec, I just did that.   Learning something new everyday!! Thanks.

My problem is as follows:For eg., the fields on my form are - item1, item2,total,grandtotal. item1*item2 the result goes to 'total' and to 'grandtotal' field and we are pressing F10 to get a blank page to enter the next, item1*item2 and the result(20x10=200)goes to the field 'total'. The figure we see then in the 'grandtotal' field should be this 200 plus the previous total.  Can we do this in Sesame? If we do what is the programming? Help is requested.
Mathew Verghese