Instead of using many if/else statements I thought I'd use Select Case Statements.
But the variable I'm trying to use is from a database field and I can't get the two working.
This is what I have.
Select Case (RS_Event.Fields.Item("location").Value)
result = "Alpha Station"
result = "Delta Station"
result = "All Stations"
What am I doing wrong?
Thank you in advance.