I am running a query that pulls in thousands of rows of data that include: agency, date, product. But, it gives me a complete list of every transaction. I want it to combine products for a date for an agency. Does that make sense? I guess I want it to do what a pivot table would do, but don't know how to do it in access.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Group or Sum alike records
- Thread starter noletwin1
- Start date
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 73,474
- Office Version
- 365
- Platform
- Windows
Those are known as Aggregate Queries, where you usually group by certain fields, and may take mathematical functions of others (like SUM, AVG, MIN, MAX).
The link mole99 sent shows how to do it via the SQL code directly, but in using the Query Builder, just hit the Totals button (looks like a Sigma).
That will add a Totals row under each field, and you can decide which fields you want to group by, and which ones you want to apply a function to (all displayed fields MUST have a selection in this Totals row).
The link mole99 sent shows how to do it via the SQL code directly, but in using the Query Builder, just hit the Totals button (looks like a Sigma).
That will add a Totals row under each field, and you can decide which fields you want to group by, and which ones you want to apply a function to (all displayed fields MUST have a selection in this Totals row).
Upvote
0
Similar threads
- Question
