If then if statements

[Angelo]

I hope I can ask this question without confusing anyone. I
have created a report that I need one text box [Unit cost]
to choose between 10 different text boxes ([1-2 units], [3-
4 units], [5-6 units], [7-10 units] etc) depending on
another text box [Quantity]. In other words, depending on
the [quantity], I need the [Unit cost]textbox to choose
the correct [qty of units]textbox.

 

[Rick Brandt]

I hope I can ask this question without confusing anyone. I
have created a report that I need one text box [Unit cost]
to choose between 10 different text boxes ([1-2 units], [3-
4 units], [5-6 units], [7-10 units] etc) depending on
another text box [Quantity]. In other words, depending on
the [quantity], I need the [Unit cost]textbox to choose
the correct [qty of units]textbox.

Check help file for the Switch() function.