//Select example 1
Select {Customer.Fax}[1 To 3]
Case "604", "250" :
"BC"
Case "206", "509", "360" :
"WA"
Default :
"";
End Select
and
dim value as string
value = "b"
dim value2 as string
value2 = "z"
dim output as string
output = "other"
Select Case value
Case "a"
Select Case value2
Case "z"
output = "a"
End Select
Case "b"
Select Case value2
Case "z"
Output = "b"
End Select
End Select
formula = output
To be able to use the same nested Select Case statement in all three versions,
use Basic syntax. |