Hi,
I'm having a small problem with using Case Select. This is my code so far, but i'm not sure how to get it to work with the two conditions at the bottom. It says END OF STATEMENT Expected. So what is the format for the >=100000000 and <=15000000 ?
CODE
Select Case strRegion
Case "east"
Select Case dblSales
Case Is < 10000000
dblDiscount = dblSales * 0.025
dblTotal = dblSales - dblDiscount
case is >= 100000000 and <= 15000000