I am having a hard time finding the answer to this. In form view I want to add field 1 to field 2 and get the sum in field 3. All are formatted number fields. Field 1 = Amt, Field 2 = Tax, Field 3 = Total of 1 and 2. Auto filled when entering field 3. I am using windows 10, LO ver. 6.2.8.2 (x64)
Please, when posting include OS, specific LO version and database used. This may be necessary to answer the question as it is here.
Making people search through your old questions is not reliable since these items may have changed.
Hello,
In Base there is no direct method on a form to add data in control A to data in control B giving result in control C. To do this you must either do this with a Query (results available only after record is updated and saved) or by writing a macro (results available as data is entered).
My answer in this post contains a sample with both methods → Base Form data uneditable. The second sample contains both methods.
Now the queries may present another problem. Depending upon LO version and database used (neither specified in question) there may be a problem with Firebird embedded database in some versions of LO. The decimal value is not correct. This can be overcome by using a CAST in the SQL. Examples of this are in these posts:
and
Thanks for answer Ratslinger.