Join Adam Wilbert for an in-depth discussion in this video Nesting IIf functions, part of Access 2010: Queries.
In the last movie, we took a look at how we can use a conditional statement to…return one of two values.…We would supply an expression, and depending on whether that expression is true…or false, we would get a branching decision tree.…Now we can nest conditional statements together, so instead of a true part, we…might evaluate to a second IIf statement, or instead of false, we might go to…a second or third IIf statement that way.…Now if we nest multiple conditional statements together, we can get a branching…decision-making tree.…This will function much like a flowchart where we'll start at the top and…depending if the statement is true or false, we'll move left or right, we'll…evaluate with a second expression, and again move left and right from there.…
At the end of the chain, we can have four expressions returned, four different…values depending on how it flowed through the chart.…Let's go ahead and take a look at this concept in Access and we'll apply it to…a sales tax calculation.…So let's create a query that decides whether or not we should be charging sales…
- Naming conventions and best practices
- Working with joins
- Using comparison operators
- Defining criteria for select queries
- Creating parameter queries
- Creating calculated fields
- Working with dates and times
- Using the Expression Builder
- Creating conditional statements
- Making, deleting and appending records
- Building reports
Skill Level Intermediate
1. Creating Queries in Access
2. Creating Simple Select Queries
3. Creating Parameter Queries
Creating a combo box4m 30s
4. Applying Aggregate Calculations (aka Totals Queries)
5. Working with Dates in Queries
6. Understanding Conditional Statements
7. Linking It All Together
8. Alternative Query Types
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.