<

Shuffle - 2 - Totals Query

Posted on
6,101 Points
1 View
1 Endorsement
Last Modified:
Experience Level: Beginner
9:05
crystal (strive4peace) - Microsoft MVP, Access
Love empowering people by teaching and helping them develop applications.
Data was imported into Access from Excel. In part 1, we examined it, and learned how to do a few things in datasheet view like filtering, sizing columns, and showing totals. To get unique values, we'll make a query and then change it to a Totals query, and use an aggregate function to calculate something. We'll use Group By, Max, and Expression.

Here are the other videos in this series:

Shuffle - 1 - Examine Data (imported from Excel)
https://www.experts-exchange.com/videos/61034/Shuffle-1-Examine-Data-imported-from-Excel.html

Shuffle - 3 - Table Design
https://www.experts-exchange.com/videos/61036/Shuffle-3-Table-Design.html

Shuffle - 4 - Append Query
https://www.experts-exchange.com/videos/61037/Shuffle-4-Append-Query.html

Video Steps

1. To change a query to an aggregate query, click 'Totals'


in the Query Setup group of the Design ribbon tab

2. Group By the key field in the Total row

3. Change Group By to Max for other fields

4. Create an Expression with Count(ID) for the number of records

1
0 Comments

Featured Post

Amazon Web Services

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

If you have a challenge of moving PST to Office 365 Online Archive, read this article to have a brief overview of how to migrate PST to Exchange Online Archive.
Today we are going to make Microsoft clients aware of tricks and tips used by Cybercriminals to bypass Microsoft Office 365 tenants. Read this post carefully to help you achieve an unbreakable security level in your Exchange Online accounts.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month