Finding string value in select case ms access
Posted on 2009-12-28
I am using a case statement to determine the number of days to ship an item depending on the zipcode of the customer - so far I have a field called txtZip:
Select Case txtZip
Case 0 To 26999, 40000 To 49999, 55000 To 58999, 60000 To 62999
DTS = 3 'DTS is Days To Ship
Case 27000 To 39999
DTS = 2
Case 50000 To 52999, 63000 To 79999
DTS = 4
Case 59000 To 59999, 80000 To 89999
DTS = 5
Case 90000 To 96199
DTS = 6
This works for US zipcodes but I need to included Canadian postal codes. These start with letters.
1) How do format the case for searching for a string that starts with letters?
2) If I wanted to do the canadian postal codes with an IF statement - what would I use to find postalcodes strings that start with a letter?
Thanks for your help.