Microsoft® Access® 2016 Programming Pocket Primer by Julitta Korol

Author:Julitta Korol
Language: eng
Format: epub
ISBN: 9781944534479
Publisher: Mercury Learning and Information
Published: 2016-02-23T00:00:00+00:00

DECISIONS BASED ON MORE THAN ONE CONDITION

The SimpleIfThen procedure you worked with earlier evaluated only a single condition in the If…Then statement. This statement, however, can take more than one condition. To specify multiple conditions in an If…Then statement, you use the logical operators AND and OR (see Table 5.2 at the beginning of the chapter). Here is the syntax of the If…Then statement with the AND operator:

If condition1 AND condition2 Then statement

In this syntax, both condition1 and condition2 must be true for Visual Basic to execute the statement to the right of the Then keyword—for example:

If sales = 10000 AND salary < 45000 Then SlsCom = sales * 0.07

In this example, condition1 is sales = 10000, and condition2 is salary < 45000.

When AND is used in the conditional expression, both conditions must be true before Visual Basic can calculate the sales commission (SlsCom). If any of these conditions is false or both are false, Visual Basic ignores the statement after Then. When it’s good enough to meet only one of the conditions, you should use the OR operator. Here is the syntax:

If condition1 OR condition2 Then statement

The OR operator is more flexible. Only one of the conditions must be true before Visual Basic can execute the statement following the Then keyword. Let’s look at this example:

If dept = "S" OR dept = "M" Then bonus = 500

In this example, if at least one condition is true, Visual Basic assigns 500 to the bonus variable. If both conditions are false, Visual Basic ignores the rest of the line.

Now, let’s look at a complete procedure example. Suppose you can get a 10% discount if you purchase 50 units of a product priced at $7.00. The IfThenAnd procedure demonstrates the use of the AND operator.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.