maximyshka
asked on
Form Calculations in Access 2010
Hi. Please see attached form 1 and table 1 behind the form
Field 3 represent combo box which user select yes; no; n/a
I need a code which do the following
if Field 3 answer is "Yes" it should add value listed in the Form field "Number" and value listed in the form field "Number 2" and put results to the Field "Calc Number". Results have to be stored in table
Qry will have it: IIf([Field3]="Yes", Field4+Field5
I need it on the form level and vba code. Also code should not delay the speed because I have slow network
Database-2.accdb
Field 3 represent combo box which user select yes; no; n/a
I need a code which do the following
if Field 3 answer is "Yes" it should add value listed in the Form field "Number" and value listed in the form field "Number 2" and put results to the Field "Calc Number". Results have to be stored in table
Qry will have it: IIf([Field3]="Yes", Field4+Field5
I need it on the form level and vba code. Also code should not delay the speed because I have slow network
Database-2.accdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry Capricorn, how can I do calculations using multiple fields and array?
For example 2 questions
1. If field1=Mike and Field3=Yes, Field4+Field4
2. If field1=Nik and Field 3=Yes, Field4+Field5
3. If field 1=Peter and Field3=Yes, Field4+Field5
4. If field 1=Sam and Field3=Yes, Field4+Field5
In addition, I need sum of calculated field if all 4 cases have field3=Yes". Please help.
Please let me know if I should ask separate question. Sorry for asking incomplete question
(I asked that as separate question
Question ID 28170251)
For example 2 questions
1. If field1=Mike and Field3=Yes, Field4+Field4
2. If field1=Nik and Field 3=Yes, Field4+Field5
3. If field 1=Peter and Field3=Yes, Field4+Field5
4. If field 1=Sam and Field3=Yes, Field4+Field5
In addition, I need sum of calculated field if all 4 cases have field3=Yes". Please help.
Please let me know if I should ask separate question. Sorry for asking incomplete question
(I asked that as separate question
Question ID 28170251)
ASKER