If then if statements

  • Thread starter Thread starter Angelo
  • Start date Start date
A

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.
 
Angelo said:
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.
Click to expand...

Check help file for the Switch() function.
 
Back
Top