Microsoft Access 2010 Bible

Chapter 18: Advanced Access Query Techniques 653 Property Description Select Crosstab Update Delete Make-Table Append Subdatashe ...

Part III: More-Advanced Access Techniques 654 products purchased by customers in particular states. Performing each of these exa ...

Chapter 18: Advanced Access Query Techniques 655 The aggregates options can be divided into four distinct categories: Group By, ...

Part III: More-Advanced Access Techniques 656 Expression You use an expression to tell Access to derive a calculated field by us ...

Chapter 18: Advanced Access Query Techniques 657 TABLE 18.4 Aggregate Options of the Total Row Option Finds Field Type Support C ...

Part III: More-Advanced Access Techniques 658 Select Avg, Min, and Max in the Total row of the three RetailPrice fields. Your ...

Chapter 18: Advanced Access Query Techniques 659 FIGURE 18.16 This datasheet was created from a total query against tblProducts. ...

Part III: More-Advanced Access Techniques 660 FIGURE 18.18 A totals query grouped by product category The recordset in Figure 18 ...

Chapter 18: Advanced Access Query Techniques 661 FIGURE 18.20 A datasheet of a multi-table aggregate query Tip You can think of ...

Part III: More-Advanced Access Techniques 662 Changing the order of the Group By fields in a totals query enables you to look at ...

Chapter 18: Advanced Access Query Techniques 663 Note The query design in Figure 18.22 does not precisely match the design of qr ...

Part III: More-Advanced Access Techniques 664 which the calculation is performed. In this case, the field you want to use as a f ...

Chapter 18: Advanced Access Query Techniques 665 Suppose that you want to sum sales for each product category. I’ve shown you si ...

Part III: More-Advanced Access Techniques 666 FIGURE 18.26 A datasheet created by an Expression total Creating Crosstab Queries ...

Chapter 18: Advanced Access Query Techniques 667 FIGURE 18.27 A crosstab query of product makes and categories Creating the cros ...

Part III: More-Advanced Access Techniques 668 Select the table or query containing the data needed by the crosstab in the next w ...

Chapter 18: Advanced Access Query Techniques 669 Predictably, the next Crosstab Wizard screen (see Figure 18.31) asks for the fi ...

Part III: More-Advanced Access Techniques 670 FIGURE 18.33 A typical crosstab query datasheet Crosstab queries are extremely pow ...

Chapter 18: Advanced Access Query Techniques 671 Understanding Action Queries So far, the queries I’ve covered are typical selec ...

Part III: More-Advanced Access Techniques 672 a datasheet. When you’re satisfied that the query is selecting the appropriate rec ...