Chapter 4. Modifying Data Using the Query Builder

4.1 Introducing the Query Builder 202

4.2 Selecting Columns in a Query 204

4.3 Creating Columns Using Mathematical Operators 206

4.4 Creating Columns Using Functions 208

4.5 Selected Functions 210

4.6 Adding a Grand Total to a Data Table 212

4.7 Adding Subtotals to a Data Table 214

4.8 Creating Summary Data Tables in a Query 216

4.9 Recoding Values in a Query 218

4.10 Changing the Result Type of Queries 220