Number Crunching with the Total Row
IN THIS CHAPTER
Doing more with the Total row
Uncovering the Total row in your query grid
Organizing with Group By
Summing your results
Counting everything at one time
Ever need to know how many orders were placed in the past month? Or total donations for last year? How about the top ten best-selling products for the current year? If you answered yes to any of these questions (or have similar questions that need answering), then this chapter is for you. Here I discuss the fabulous Total row. The Total row does it all for your data! Well, actually, it summarizes your data via the select query. (If you don’t know what a select query is or how to create one, I suggest you go back and read Chapter 13 before beginning the material in this chapter.)
Say Hello to the Total Row
In Chapter 13, I show you how simple select queries can fetch data, such as a list of volunteers who reside in California or all the details of tofu sales. The Total ...
Get Access 2019 For Dummies now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.