O'Reilly logo

Access 2013 For Dummies by Ken Cook, Laurie Ulrich Fuller

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 14

Number Crunching with the Total Row

In This Chapter

arrow Doing more with the Total row

arrow Uncovering the Total row in your query grid

arrow Organizing with Group By

arrow Summing your results

arrow Counting everything at one time

Ever need to know how many orders were placed in the past month? Or total dollar sales 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 12 before beginning the material in this chapter.)

Kissing That Calculator Goodbye via the Total Row

In Chapter 12, I show you how simple select queries can fetch data, such as a list of customers who reside in California or all the details ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required