Display running total of Table Control in LibreOffice Base form

users
#1

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

#2

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