Using a datasheet Totals row


show more Using a datasheet Totals row provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts show less
please wait ...

Using a datasheet Totals row

If you're working on a Tables Datasheet View it can be handy to see instant calculations at the bottom of my Table. I have opened my Orders Table, and up on the Home ribbon, about the middle, there is a stigma with the word Totals on it, I'll click on it and a new row appears at the bottom of my data. Note that it is not part of my Table; it stays at the bottom of my screen as I scroll. When I click in the cell at the bottom of each column a dropdown arrow appears, click on it and you'll see a number of choices appropriate to that type of data.

For our dates I can find the Average date of the order, the Count of how many orders there were, Maximum will give me the most recent date, Minimum would give me my earliest date. I'll choose Minimum-- and my first order was placed in January 10, 2006. The dropdown underneath the Customer column only allows me to Count how many orders there are, and there are 47. Underneath Product, I also only have those same choices. My Count is agai...

Using a datasheet Totals row
Video duration: 2m 0s 3h 43m Intermediate

Viewers:

Using a datasheet Totals row provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts

Subject:
Business
Software:
Access
Author:
please wait ...