Microsoft Access 2010 Bible
Chapter 5: Using Operators and Expressions in Access ............................................................... 173 There a ...
Part I: Access Building Blocks 174 The parentheses around [Price] * [DiscountPercent] instruct Access to perform this oper- atio ...
Chapter 5: Using Operators and Expressions in Access 175 The integer division operator: \ The integer division operator takes an ...
Part I: Access Building Blocks 176 The tricky thing about modulo division is that the returned value is the remainder after inte ...
Chapter 5: Using Operators and Expressions in Access 177 The less-than operator: < The less-than operator (<) returns a lo ...
Part I: Access Building Blocks 178 String operators Access has three string operators for working with strings. Unlike the mathe ...
Chapter 5: Using Operators and Expressions in Access 179 The addition operator (+) also concatenates two character strings. For ...
Part I: Access Building Blocks 180 string. The returned value is True, False, or Null. The Like and Not Like operators are case- ...
Chapter 5: Using Operators and Expressions in Access 181 Table 5.1 shows the five wildcards you can use with the Like operator: ...
Part I: Access Building Blocks 182 The logical And operator depends on how the two operands are evaluated by Access. Table 5.2 d ...
Chapter 5: Using Operators and Expressions in Access 183 TABLE 5.3 Or Expression Results Expression1 Expression2 Expression1 Or ...
Part I: Access Building Blocks 184 Miscellaneous operators Access has three very useful miscellaneous operators: Between...And R ...
Chapter 5: Using Operators and Expressions in Access 185 The return value of the In operator can be negated with Not: If strCity ...
Part I: Access Building Blocks 186 Integer division Modulus division Addition and/or subtraction (left to right) String concate ...
Chapter 5: Using Operators and Expressions in Access 187 The Boolean precedence The Boolean operators follow this order of prece ...
Part I: Access Building Blocks 188 Cross-Reference Chapter 4 gives an in-depth explanation of working with queries. Using query ...
Chapter 5: Using Operators and Expressions in Access 189 FIGURE 5.1 The QBE pane shows a simple criterion asking for all models ...
Part I: Access Building Blocks 190 FIGURE 5.2 Using And and Or criteria in a query Or And FIGURE 5.3 Creating complex criteria w ...
Chapter 5: Using Operators and Expressions in Access 191 You learn how to create this type of complex query in the “Entering Cri ...
Part I: Access Building Blocks 192 The And/Or operators are the most common operators when working with complex criteria. The op ...
«
7
8
9
10
11
12
13
14
15
16
»
Free download pdf