Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenFri, 17 Nov 2017 04:11:03 +0100Simple Multiplication in Basehttps://ask.libreoffice.org/en/question/138208/simple-multiplication-in-base/ OK, I am probably thinking way to hard and searching. But I can't seem to find an answer. I am trying to Get a Total from two Amounts via Multiplication. I am very new to Base. I have read that SELECT"A" + "B" method, But no idea where to input that. Any help would be appreciated or links, I just can't seem to find a proper solution. Thank you much.
Using Libre Office Base V 5.3.6.1 x64Fri, 17 Nov 2017 00:16:03 +0100https://ask.libreoffice.org/en/question/138208/simple-multiplication-in-base/Comment by Ratslinger for <p>OK, I am probably thinking way to hard and searching. But I can't seem to find an answer. I am trying to Get a Total from two Amounts via Multiplication. I am very new to Base. I have read that SELECT"A" + "B" method, But no idea where to input that. Any help would be appreciated or links, I just can't seem to find a proper solution. Thank you much.</p>
<p>Using Libre Office Base V 5.3.6.1 x64</p>
https://ask.libreoffice.org/en/question/138208/simple-multiplication-in-base/?comment=138209#post-id-138209Hello, Need some further clarification. Where are the two amounts coming from? Table fields? Controls? Where is the result going to? Table field? Control? Is this a result of a Query? Please be clear on what you are trying to accomplish & what you have.Fri, 17 Nov 2017 00:27:43 +0100https://ask.libreoffice.org/en/question/138208/simple-multiplication-in-base/?comment=138209#post-id-138209Comment by Blacksmithkazuma for <p>OK, I am probably thinking way to hard and searching. But I can't seem to find an answer. I am trying to Get a Total from two Amounts via Multiplication. I am very new to Base. I have read that SELECT"A" + "B" method, But no idea where to input that. Any help would be appreciated or links, I just can't seem to find a proper solution. Thank you much.</p>
<p>Using Libre Office Base V 5.3.6.1 x64</p>
https://ask.libreoffice.org/en/question/138208/simple-multiplication-in-base/?comment=138217#post-id-138217That is hard, because Not sure. I have a a Client Order List that is a simple design. 6 slots for items, quantity, price and total. I am trying to multiply the Quantity and price to get the total. I can use the data from both the Table and a Quarry. Sorry for the late reply.Fri, 17 Nov 2017 03:17:23 +0100https://ask.libreoffice.org/en/question/138208/simple-multiplication-in-base/?comment=138217#post-id-138217Comment by Blacksmithkazuma for <p>OK, I am probably thinking way to hard and searching. But I can't seem to find an answer. I am trying to Get a Total from two Amounts via Multiplication. I am very new to Base. I have read that SELECT"A" + "B" method, But no idea where to input that. Any help would be appreciated or links, I just can't seem to find a proper solution. Thank you much.</p>
<p>Using Libre Office Base V 5.3.6.1 x64</p>
https://ask.libreoffice.org/en/question/138208/simple-multiplication-in-base/?comment=138218#post-id-138218if anything i could possibly send you the odb file.Fri, 17 Nov 2017 03:18:40 +0100https://ask.libreoffice.org/en/question/138208/simple-multiplication-in-base/?comment=138218#post-id-138218Comment by Ratslinger for <p>OK, I am probably thinking way to hard and searching. But I can't seem to find an answer. I am trying to Get a Total from two Amounts via Multiplication. I am very new to Base. I have read that SELECT"A" + "B" method, But no idea where to input that. Any help would be appreciated or links, I just can't seem to find a proper solution. Thank you much.</p>
<p>Using Libre Office Base V 5.3.6.1 x64</p>
https://ask.libreoffice.org/en/question/138208/simple-multiplication-in-base/?comment=138219#post-id-138219Basic DB design - don't store information which can be generated from other fields. If you need this figure later on, it can be generated as in the sample provided. Did you look at it?Fri, 17 Nov 2017 03:20:47 +0100https://ask.libreoffice.org/en/question/138208/simple-multiplication-in-base/?comment=138219#post-id-138219Comment by Blacksmithkazuma for <p>OK, I am probably thinking way to hard and searching. But I can't seem to find an answer. I am trying to Get a Total from two Amounts via Multiplication. I am very new to Base. I have read that SELECT"A" + "B" method, But no idea where to input that. Any help would be appreciated or links, I just can't seem to find a proper solution. Thank you much.</p>
<p>Using Libre Office Base V 5.3.6.1 x64</p>
https://ask.libreoffice.org/en/question/138208/simple-multiplication-in-base/?comment=138221#post-id-138221It blocked the Macros, not sure how to reenable themFri, 17 Nov 2017 03:25:33 +0100https://ask.libreoffice.org/en/question/138208/simple-multiplication-in-base/?comment=138221#post-id-138221Comment by Ratslinger for <p>OK, I am probably thinking way to hard and searching. But I can't seem to find an answer. I am trying to Get a Total from two Amounts via Multiplication. I am very new to Base. I have read that SELECT"A" + "B" method, But no idea where to input that. Any help would be appreciated or links, I just can't seem to find a proper solution. Thank you much.</p>
<p>Using Libre Office Base V 5.3.6.1 x64</p>
https://ask.libreoffice.org/en/question/138208/simple-multiplication-in-base/?comment=138222#post-id-138222The macro only applies to the CalcFields form. The QueryMultiply form should work without a problem.Fri, 17 Nov 2017 03:29:00 +0100https://ask.libreoffice.org/en/question/138208/simple-multiplication-in-base/?comment=138222#post-id-138222Comment by Ratslinger for <p>OK, I am probably thinking way to hard and searching. But I can't seem to find an answer. I am trying to Get a Total from two Amounts via Multiplication. I am very new to Base. I have read that SELECT"A" + "B" method, But no idea where to input that. Any help would be appreciated or links, I just can't seem to find a proper solution. Thank you much.</p>
<p>Using Libre Office Base V 5.3.6.1 x64</p>
https://ask.libreoffice.org/en/question/138208/simple-multiplication-in-base/?comment=138223#post-id-138223BTW - For macro enabling, from menu `Tools->Options` then under `LibreOffice->Security` select `Macro Security` button. On next dialog, select `Medium`. Click OK, OK & close & reopen .odb. When prompted, select `Enable macros` for the document.Fri, 17 Nov 2017 03:32:50 +0100https://ask.libreoffice.org/en/question/138208/simple-multiplication-in-base/?comment=138223#post-id-138223Comment by Ratslinger for <p>OK, I am probably thinking way to hard and searching. But I can't seem to find an answer. I am trying to Get a Total from two Amounts via Multiplication. I am very new to Base. I have read that SELECT"A" + "B" method, But no idea where to input that. Any help would be appreciated or links, I just can't seem to find a proper solution. Thank you much.</p>
<p>Using Libre Office Base V 5.3.6.1 x64</p>
https://ask.libreoffice.org/en/question/138208/simple-multiplication-in-base/?comment=138228#post-id-138228Not sure if you are aware but LO documentation is located [here](https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Handbook).Fri, 17 Nov 2017 03:56:17 +0100https://ask.libreoffice.org/en/question/138208/simple-multiplication-in-base/?comment=138228#post-id-138228Comment by Blacksmithkazuma for <p>OK, I am probably thinking way to hard and searching. But I can't seem to find an answer. I am trying to Get a Total from two Amounts via Multiplication. I am very new to Base. I have read that SELECT"A" + "B" method, But no idea where to input that. Any help would be appreciated or links, I just can't seem to find a proper solution. Thank you much.</p>
<p>Using Libre Office Base V 5.3.6.1 x64</p>
https://ask.libreoffice.org/en/question/138208/simple-multiplication-in-base/?comment=138229#post-id-138229One last question, I am using the QueryMultiply to do this. I have it written where my Total 1 table/query was at. I replaced with "Quantity 1"*"Price 1" in that column. It works once the Record is saved. But the "Total" on the Form does not save to the Table. How could I do that? if possible?Fri, 17 Nov 2017 03:57:22 +0100https://ask.libreoffice.org/en/question/138208/simple-multiplication-in-base/?comment=138229#post-id-138229Comment by Ratslinger for <p>OK, I am probably thinking way to hard and searching. But I can't seem to find an answer. I am trying to Get a Total from two Amounts via Multiplication. I am very new to Base. I have read that SELECT"A" + "B" method, But no idea where to input that. Any help would be appreciated or links, I just can't seem to find a proper solution. Thank you much.</p>
<p>Using Libre Office Base V 5.3.6.1 x64</p>
https://ask.libreoffice.org/en/question/138208/simple-multiplication-in-base/?comment=138230#post-id-138230As stated a couple of comments ago, that is bad practice. If you insist on that, it needs to be done using a macro. Before updating the record (an Event) the field is calculated, moved into the proper spot & then the record is allowed to be updated. You really should review the docs. On same page is `Planning and Designing your Database` and many samples. You question reveals the need for multiple tables with relationships in order to reduce errors & redundancy.Fri, 17 Nov 2017 04:05:38 +0100https://ask.libreoffice.org/en/question/138208/simple-multiplication-in-base/?comment=138230#post-id-138230Comment by Ratslinger for <p>OK, I am probably thinking way to hard and searching. But I can't seem to find an answer. I am trying to Get a Total from two Amounts via Multiplication. I am very new to Base. I have read that SELECT"A" + "B" method, But no idea where to input that. Any help would be appreciated or links, I just can't seem to find a proper solution. Thank you much.</p>
<p>Using Libre Office Base V 5.3.6.1 x64</p>
https://ask.libreoffice.org/en/question/138208/simple-multiplication-in-base/?comment=138232#post-id-138232If you want to view a sample .odb where this is done see my answer in [this post](https://ask.libreoffice.org/en/question/94611/base-form-data-uneditable/).Fri, 17 Nov 2017 04:11:03 +0100https://ask.libreoffice.org/en/question/138208/simple-multiplication-in-base/?comment=138232#post-id-138232Comment by Blacksmithkazuma for <p>OK, I am probably thinking way to hard and searching. But I can't seem to find an answer. I am trying to Get a Total from two Amounts via Multiplication. I am very new to Base. I have read that SELECT"A" + "B" method, But no idea where to input that. Any help would be appreciated or links, I just can't seem to find a proper solution. Thank you much.</p>
<p>Using Libre Office Base V 5.3.6.1 x64</p>
https://ask.libreoffice.org/en/question/138208/simple-multiplication-in-base/?comment=138231#post-id-138231Very well, thank you so much for your time. Will start running through them once I have a little more free time. Again thank you.Fri, 17 Nov 2017 04:10:11 +0100https://ask.libreoffice.org/en/question/138208/simple-multiplication-in-base/?comment=138231#post-id-138231Comment by Blacksmithkazuma for <p>OK, I am probably thinking way to hard and searching. But I can't seem to find an answer. I am trying to Get a Total from two Amounts via Multiplication. I am very new to Base. I have read that SELECT"A" + "B" method, But no idea where to input that. Any help would be appreciated or links, I just can't seem to find a proper solution. Thank you much.</p>
<p>Using Libre Office Base V 5.3.6.1 x64</p>
https://ask.libreoffice.org/en/question/138208/simple-multiplication-in-base/?comment=138227#post-id-138227The Formula for the answer was confusing, I wont lie. But after a little more research I finally Figured it out. So between you answers and advice and another forum post I was able to figure it out. Thank you so much for your time and dealing with my lack of common sense hahaFri, 17 Nov 2017 03:54:03 +0100https://ask.libreoffice.org/en/question/138208/simple-multiplication-in-base/?comment=138227#post-id-138227Answer by Ratslinger for <p>OK, I am probably thinking way to hard and searching. But I can't seem to find an answer. I am trying to Get a Total from two Amounts via Multiplication. I am very new to Base. I have read that SELECT"A" + "B" method, But no idea where to input that. Any help would be appreciated or links, I just can't seem to find a proper solution. Thank you much.</p>
<p>Using Libre Office Base V 5.3.6.1 x64</p>
https://ask.libreoffice.org/en/question/138208/simple-multiplication-in-base/?answer=138215#post-id-138215Hello,
While waiting for a reply I put a sample together. There are two forms: `QueryMultiply` and `CalcFields`.
QueryMultiply uses a simply query as it data source:
SELECT "Name", "Amount1", "Percent1", "Amount1" * "Percent1" AS "CalcTotal", "ID" FROM "Table1"
And uses that to display the result. Of course the result is only available after the record is entered.
CalcFields uses a macro to get the result of the amounts entered in the Numeric fields.
Sample: [SQLselect1.odb](/upfiles/15108802125166504.odb)
If this answers your question please click on the ✔ (upper left area of answer).Fri, 17 Nov 2017 01:58:33 +0100https://ask.libreoffice.org/en/question/138208/simple-multiplication-in-base/?answer=138215#post-id-138215