How would I go about adding numeric values from 2 textboxes produced by a switch function?
Example:
Text box #1 - Control Source: =Switch([Q4]="1","7",[Q4]="2","6",[Q4]="3","5",[Q4]="4","4",[Q4]="5","3",[Q4]="6","2",[Q4]="7","1")
Text box #2 - Control Source: =Switch([Q11]="1","7",[Q11]="2","6",[Q11]="3","5",[Q11]="4","4",[Q11]="5","3",[Q11]="6","2",[Q11]="7","1")
In this report, i need to add the two numbers that result from this switch function, is that possible?
I try to make a new textbox and in the control source function i try this: =Sum([Text1]+[Text2]) but it's not working.
Any ideas on how I can get the results from these two switch function text boxes to calculate?
Example:
Text box #1 - Control Source: =Switch([Q4]="1","7",[Q4]="2","6",[Q4]="3","5",[Q4]="4","4",[Q4]="5","3",[Q4]="6","2",[Q4]="7","1")
Text box #2 - Control Source: =Switch([Q11]="1","7",[Q11]="2","6",[Q11]="3","5",[Q11]="4","4",[Q11]="5","3",[Q11]="6","2",[Q11]="7","1")
In this report, i need to add the two numbers that result from this switch function, is that possible?
I try to make a new textbox and in the control source function i try this: =Sum([Text1]+[Text2]) but it's not working.
Any ideas on how I can get the results from these two switch function text boxes to calculate?