Page 1 of 1

### [Solved] Calculation based on results of 2 other fields

Posted: Mon Sep 10, 2018 2:50 pm
Hi, I have a form which requires a simple calculation to be shown on the form (used to quickly estimate a value).
So the used will input a number in field A, field B will be a result of the field chosen from a ListBox and field C will be (A * B).
The form does not need to store the result as it is only an estimate. The user can then choose to use the estimate by entering this manually in another field which will be stored. I was thinking that a Viewtable from a query may be the way ahead but despite searching the forum nothing has helped.
Is there a way on performing a simple calculation as mentioned above? I will also be looking to use other calculations as I progress which should be along the same lines as this.

many thanks

### Re: Calculation based on results of 2 other fields in form

Posted: Mon Sep 10, 2018 4:01 pm
Form source type: SQL or Query
Source: SELECT *, "A" * "B" AS "AxB" FROM "Table" (or the name of the query with this SQL)

### Re: Calculation based on results of 2 other fields in form

Posted: Tue Sep 11, 2018 4:14 pm
Villeroy wrote:Form source type: SQL or Query
Source: SELECT *, "A" * "B" AS "AxB" FROM "Table" (or the name of the query with this SQL)

OK, so i can get a query to calculate the desired result. Cant get the result to show in the form yet, but still trying.

Thanks Villeroy, very helpful as always

### Re: Calculation based on results of 2 other fields in form

Posted: Tue Sep 11, 2018 4:28 pm
Add any type of text box or numeric control to the form. Linked field = AxB

### Re: Calculation based on results of 2 other fields in form

Posted: Wed Sep 12, 2018 12:08 pm
Villeroy wrote:Add any type of text box or numeric control to the form. Linked field = AxB

Yes, believe i tried this unsuccessfully. I added the field to a subform, changed subform to Query with content coming from the Q_LabourEst.
I then had the data field linked to the relevant result field in the query.
As is apparent I am no expert but believe this should work so probably have an issue somewhere else.
This is on the same form where i am trying to modify without creating a duplicate. I will concentrate on that one as i think I can get this working.