Microsoft Access 2010 Bible

Chapter 5: Using Operators and Expressions in Access 193 around field names that contain spaces or punctuation characters. An ex ...

Part I: Access Building Blocks 194 FIGURE 5.5 The query design window showing tblCustomers open You don’t have to enter an equal ...

Chapter 5: Using Operators and Expressions in Access 195 This is, of course, the opposite use of quotation marks as the previous ...

Part I: Access Building Blocks 196 Click the Criteria cell of the Notes field and enter red as the criteria. Be sure to put ...

Chapter 5: Using Operators and Expressions in Access 197 After creating this query, click on the Datasheet View command to view ...

Part I: Access Building Blocks 198 TABLE 5.6 Using Wildcards with the Like Operator Expression Field Used In Results of Criteria ...

Chapter 5: Using Operators and Expressions in Access 199 Type Not NY in the cell. Access automatically places quotation marks ...

Part I: Access Building Blocks 200 FIGURE 5.9 Criteria set for products with low inventory The criteria applied to numeric field ...

Chapter 5: Using Operators and Expressions in Access 201 Entering OLE object criteria You can specify criteria for OLE objects: ...

Part I: Access Building Blocks 202 l (^) Customer 3 lives in NY and CA — the expression is True. l Customer 4 lives in CT — the ...

Chapter 5: Using Operators and Expressions in Access 203 FIGURE 5.11 Using the Or cell of the QBE pane. You can place criteria v ...

Part I: Access Building Blocks 204 FIGURE 5.12 Using the In operator to find all records for buyer state being either AZ, CA, or ...

Chapter 5: Using Operators and Expressions in Access 205 have purchased products between October 1, 2012, and March 31, 2013, in ...

Part I: Access Building Blocks 206 FIGURE 5.14 Using the Between...And operator. The results are the same as the query in Figure ...

Chapter 5: Using Operators and Expressions in Access 207 Logically, a Null is neither True nor False. A Null field is not equiva ...

Part I: Access Building Blocks 208 Tip When using the Is Null and Is Not Null operators, you can enter Null or Not Null and Acce ...

Chapter 5: Using Operators and Expressions in Access 209 expression for this example is (Criteria1 And Criteria2 And Criteria3) ...

Part I: Access Building Blocks 210 FIGURE 5.17 Using the Or operator between fields. “Or” because criteria are in different rows ...

Chapter 5: Using Operators and Expressions in Access 211 FIGURE 5.18 A simple rearrangement in the QBE grid results in a very di ...

Part I: Access Building Blocks 212 FIGURE 5.19 Using Ands and Ors in a select query “Or” because criteria are in different rows ...