Microsoft Access Conditional Analyses
Most programming languages have If/Then/Else or Case/Else statements that make decisions in the code. With Microsoft Access, conditional analyses can be accomplished with Visual Basic for Applications (VBA). Developers have the flexibility to add the VBA versions IIF() and Switch() statements to queries to build some decision-making ability into queries to provide analysis of the data.