How to use IIF and SWITCH functions in MS Access - Office 365
IIF is short name for "Immediate If" function. The IIF function replicates the functionality of an IF statement. IIF function tests an expression and if it's true will return a value and if it's false it returns another value. Sometimes the condition you need to test for is too complex then you need to use nested IIF functions that is an IIF function in another IIF function. You can use SWITCH function if you want to avoid nesting of IIF function. SWITCH function argument list consists of pairs of expressions and values. The expressions are evaluated from left to right and the value associated with the first expression to evaluate to true is returned.
![Friday Night Funkin V.S. Garcello | Fading - Smoke 'Em Out Struggle [LoFi Cover by Nathsil Song]](https://images.videosashka.com/watch/_peb5802S0Q)
