On 12/11/2013 07:25 AM, Lelanthran Manickum wrote:
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.
I posted this on stackoverflow with no success; perhaps someone where can
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.
To unsubscribe e-mail to: firstname.lastname@example.org
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
Impressum (Legal Info)
: 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