[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
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