Welcome! Log In Create A New Profile

Advanced

Running total in a table

Posted by issah 
issah
Running total in a table
February 04, 2009 07:08PM
Has anyone tried including a running total column in a table? Any ideas would be helpful.

Thanks

issah
Fabrice Harari
Re: Running total in a table
February 05, 2009 02:35PM
Hi Issah...

to do this, you will have to either use a memory table or strictly limit what functionality are available in your file/query table....

In a memory table, you just have to calculate the running total and add it as you add your lines...

In a file table, you would have to calculate/add the running total when you DISPLAY the line, and the problem is of course that records are read only when a line needs to be displayed, so if you allow the SEARCH function in your table, the user will arrive on a record without reading the previous ones, and you won't be able to calculate your total...

Same problem with the sort capabilities (but that is true also in a memory table,where yowould have to recalculate the total for each sort)

Best regards

issah
Re: Running total in a table
February 05, 2009 05:13PM
Thanks and will give it a try.

Regards

issah
Author:

Your Email:


Subject:


Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: