Microsoft Access 2010 Bible

Chapter 20: Advanced Access Report Techniques 713 To emphasize the alphabetical grouping, a text box containing the first charac ...

Part III: More-Advanced Access Techniques 714 FIGURE 20.6 rptSalesJanuaryAlpha2 in Design view Notice the CompanyName group head ...

Chapter 20: Advanced Access Report Techniques 715 FIGURE 20.7 The January sales data grouped by each week during the month FIGUR ...

Part III: More-Advanced Access Techniques 716 FIGURE 20.9 The Design view of rptSalesJanuaryByWeek. Notice the expression in the ...

Chapter 20: Advanced Access Report Techniques 717 FIGURE 20.11 The simple query underlying rptTabularBad The query in Figure 20. ...

Part III: More-Advanced Access Techniques 718 Change the Hide Duplicates property to Yes. The default is No, which directs Acc ...

Chapter 20: Advanced Access Report Techniques 719 Hiding a page header Sometimes you need to display a page header or footer on ...

Part III: More-Advanced Access Techniques 720 Use the Page property to display the current page number in the page header or foo ...

Chapter 20: Advanced Access Report Techniques 721 FIGURE 20.14 An interesting query that sums data and sorts the query results i ...

Part III: More-Advanced Access Techniques 722 Adding a Ranking column to the simple report you see in Figure 20.15 is not diffic ...

Chapter 20: Advanced Access Report Techniques 723 FIGURE 20.17 The Running Sum column provides a ranking for each customer in or ...

Part III: More-Advanced Access Techniques 724 The bullet is added by exploiting a Windows feature. Position the text insertion c ...

Chapter 20: Advanced Access Report Techniques 725 You might want to add other special characters to the control. For a complete ...

Part III: More-Advanced Access Techniques 726 Only when the information contained in the control is needed do you reset the Visi ...

Chapter 20: Advanced Access Report Techniques 727 FIGURE 20.22 rptPriceList in Design view reveals how this effect is implemente ...

Part III: More-Advanced Access Techniques 728 Avoiding empty reports If Access fails to find valid records to insert into the De ...

Chapter 20: Advanced Access Report Techniques 729 Alternatively, you could create the following function, which performs the sam ...

Part III: More-Advanced Access Techniques 730 FIGURE 20.24 Vertical lines in rptVerticalLines help segregate data. The syntax of ...

Chapter 20: Advanced Access Report Techniques 731 Adding a blank line every n records Detail sections chock-full of dozens or hu ...

Part III: More-Advanced Access Techniques 732 FIGURE 20.26 This report trick uses hidden unbound text boxes in the Detail sectio ...