I have about 70 letters (each letter has a certain number) according to their number they could fall into 3 different categories, I am trying to do a “If – Else Statement”, but I don’t want to do 70 individual If Else Statements for each letter, and was wondering if there’s a way that I can have “3” different If statements according to category, and just include the Letter number as a OR, AND, something to that affect, and then if there’s a new letter that comes about that I don’t have, it returns the result that is in that field from original file.
FYI, The Original File only separates one of the 3 categories, every category thereafter is BLANK, this is why I need a If-Else-Then Statement to input it in my
data…
(I know I can do 70 different If-Else-Then statements, but that’s a lot) and way over 70 letters
For example,
IIf([LETTER_NO] IS "2243" Or "2244" Or “4678” Or “5633”,"Mainframe",
IIf([LETTER_NO] IS "1234" Or "3256" Or “6829” Or “7202”,"LOCAL",
IIf([LETTER_NO] IS "4256" Or "7892","EMAIL", [LETTER_NO])
The File once imported in Access looks like this (in the original File it only identifies the “E” (Email) and doesn’t specify the other letter type it leaves it blank
Letter_# - Letter_TYPE
2243
2244
4678
5633
1234
3256
6829
7202
4256 - E
7892 - E
2212 - E
3684 - E
Ultimately I want it to look like this
MainFrame - Local - Email
2243 -1234 - 4256
2244 - 3256 - 7892
4678 - 6829 - 2212
5633 - 7202 - 3684
Someone informed me to try a “Case Statement” I don’t know how that goes?