Perhaps you need to begin over as far as you fields are concerned. First
of all, you only need two fields in the table: Fee1 and Fee2. You also
need a primary key which is listed first. Fee1 and fee2 need to be given
the properties you want for them. The primary key has to have "entry
required" selected. I prefer it to also have this property: INTEGER.
Save the table. When I did this, I named the table, Currency, and the
primary key, ID.
Second, create a query in SQL View. Use this SQL statement:
SELECT "ID", "Fee1", "Fee2", "Fee1" + "Fee2" AS "Total" FROM "Currency"
Save the query giving it a name other than Currency. (You can not have a
table and query with the same name.)
Running the query, the ID field has <AutoField>. You can not enter
values for Fee1 and Fee2. Typing <ENTER> after entering values for Fee1
and Fee2 will place the sum in the Total column.
Now you can either use the Form wizard to create a form from the query
or use Girvin's suggestion for connecting your present form to the query.
Dan
On 10/13/2018 07:07 AM, Adam Fenn wrote:
On 11 Oct 2018, at 23:39, Girvin Herr <[email protected]> wrote:
I am not sure where you are wanting this total.
I want it in the same form as fee1 and fee2.
First, you need to create a query,
I'm familiar with this.
Then you need to have your form attach itself to the query rather than the table. You do this by opening the form in "Edit" mode and selecting the
"Form" icon. At this time, you should have a popup called "Form Properties". Select the "Data" tab and in the "Content
type" list select "Query". Then select your new query in the "Content" list. Then you can add the new "Total" field to your
form.
When I try to add the field using the Add Field icon LO crashes without fail.
Is there a way around this?
Thank you for your help Girvin.
On 10/11/18 11:39 AM, Adam Fenn wrote:
I have three currency fields - 'Fee1', 'Fee2' and 'Total'. How do I add fee1
and fee2 together and put the result automatically into the Total field?
TIA
Adam.
--
To unsubscribe e-mail to: [email protected]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
--
To unsubscribe e-mail to: [email protected]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
