Watch the video and explore the code as you learn to create a nested IIf function call when you design a query using the new Access 2010 Expression Builder. Author: Ken Getz (MVP)
Read more from the original source:
Using the New Expression Builder to Build If-Then Statements in Access 2010 Applications (Visual How To)