Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


On 12/11/2013 07:25 AM, Lelanthran Manickum wrote:
Hi all


I posted this on stackoverflow with no success; perhaps someone where can
help:

I'm using LibreOffice 4.0 + MySQL on Linux. I have a form which contains a
Table Control. This table has a column that is an integer. I would like to
have a different control on the same form that keeps a running total of the
above-mentioned integer field in the above-mentioned table control.

So far I tried using a parameterised query that gets executed in a subform
(which holds the text box control that displays the result of the query),
but this prompts me for the parameter each time I change a row in the table.


Basically the table control houses a table which is used to record
line-items on a purchase receipt. I want a separate control that displays a
running total as the user enters line-items.


Warm Regards

Lelanthran

There are things that I do not understand about your table control. You mentioned a running total of a field, but of what is it a running total? Do you need to use the SUM function, or would the COUNT function work? Without knowing what is the purpose of the field, it is hard to know how to get the information you want to appear in the form. A query is likely what you would need to use to solve your problem. But without knowing what fields are contained in the table control, suggestions as to how to solve the problem are hard to make. You will need to use a query for what you want. It will contain your field of interest and at least another field which will limit the query output to the rows which are of interest to you. For example, I have a form containing the foods I eat. One table control contains the nutitional information about the foods as well as a field with a checkbox to select the foods I eat. I want to know the quanity of protein, carbohydrates, and fats that I consume (one query). In another query, I want to know what are the percentage of total calories that I get from protein, carbohydrates, and protein. Using the field with the checkbox, I can limit the data to the rows which have a check. Then I can add, multiply, and divide in the query to get the results I want.

--Dan

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.