Search results

Is it possible to use a switch function in a query?

Q4 is numeric, so removing the quotes did it! Thanks Pat, u rule.

Okay, I'm with you so far. But, when I do that, for example, if one text box value is "2" and the second text box "3", and i put =[Text1]+[Text2] then it shows 23 instead of adding the two numbers to 5.

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

Then how do you get the number from the second text box into the table if =IIf([txtBox1]-5<0,0,[txtBox1]-5) is in your control source already?

In the simplest terms... Drop down box on form, choose 1, 2, 3 or 4 On a couple of items they need to be reverse coded. So, if they choose 1, it needs to be entered as 4 in the database.

I am building a database where test (psychological assessments) results are entered in a form, stored and can be pulled up in a report by each assessment to see a specific test score. For just a few of the say 20 items on an assessment they are "reverse coded", for example, the subject has a...

That worked...thanks Pat!

So, how do you get these fields to add the numbers instead of concatenation? In the original example above, he stated both text boxes were the number 10. Am I not understanding something from this example? Thanks!