Welcome to another free tutorial brought to you by Access Learning Zone. My name is Richard Ross. In this lesson, I'm going to teach you about the switch function, which is an alternative to nesting a bunch of if functions together. The switch function was added in Access 2007, and at the time, I even missed it myself. But I just recently discovered this thanks to a question from one of my students. The switch function can definitely save you some time if you're typing in big, long, complicated if functions. So here's my table setup: I've got an auto number, ID. The student's name, and the student's numeric grade, like 92, 76, and so on. And I'd like to assign them a letter grade. So 90 and up is an A, 80 to 89 is a B, and so on all the way down to D and F. Traditionally, I would do this in a query. So I'll close the table, save changes, yes. Create query design, bring in my student ID. I'll bring in the student and the grade. And right here, I would type in my if statement. Now, if you're not familiar with the if statement, I have several other videos available that teach you how to use the if function. The if function is very easy to use. It's if, IIF, that stands for immediate if, and three bits of data. First is the condition you're checking. The second part is the value if it's true. The third part is the value if it's false. And you can nest multiple if functions together. For example, I replaced the value of false with another if function. You can do this multiple times. However, if you do more than three or four, it starts to get a little unruly to read...
Award-winning PDF software
Video instructions and help with filling out and completing Can Form 2350 Toggle
