Creating an IIf function


show more Creating an IIf function provides you with in-depth training on Business. Taught by Adam Wilbert as part of the Access 2010: Queries in Depth show less
please wait ...

Creating an IIf function

In this video, we will begin writing our own conditional statements using the Query Designer in Access. We will be using the Expression Builder to help us generate proper syntax and we'll be using some mathematical expressions to evaluate our data. So let's get started. First, we need to define the question. The question we want to answer with this example is which sales team members met the goal of $20 in the month of June 2010? First, we will build a select query to fill trap only the information we need from the database. We will go up to the Create tab and create a new wuery in Design view.

We will add the Employees table, the Orders table, and the Products table. Let's go ahead and close Show Table and we will start filling in the fields. From the Employees table, let's add Employee ID and FirstName. From the Orders table we will grab the date and from the Products table we will grab the Price. Now let's start filling in our criteria. For the OrderDate, we're only...

Creating an IIf function
Video duration: 7m 31s 3h 2m Intermediate

Viewers:

Creating an IIf function provides you with in-depth training on Business. Taught by Adam Wilbert as part of the Access 2010: Queries in Depth

Subject:
Business
Software:
Access
Author:
please wait ...