By Andrew Gould

Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBAonYIurK
VBA Working with Databases playlist https://youtube.com/playlist?list=PLNIs-AWhQzclbRVLCZlsFvpz6fz2nPGbt

Get files here https://www.wiseowl.co.uk/vba-macros/videos/vba-ado-net-recordsets/sql-excel-union-total/

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link https://www.wiseowl.co.uk/donate?t=1​ to make a donation. Thanks for watching!

This video explains how to use Union queries to combine detail rows with subtotals and grand totals in a single list.

Chapters
00:00 Topic List
00:45 The Basic Setup
02:35 Creating a Summary Row
03:56 Combining Details with a Total Row
05:34 Adding Multiple Summary Rows
06:55 Adding Criteria to the Query
08:51 Sorting the Query Results
10:07 Using a Helper Column for Sorting
12:02 Removing the Helper Column
13:21 Grouping Rows
14:49 Adding the Summary Rows
15:36 Back to the Basic Example
16:48 Adding the Subtotals
18:29 Sorting Details and Subtotals
20:19 Sorting the Detail Rows
21:29 Improving the Appearance of the Results
23:21 Merging Columns
26:34 Adding the Grand Total

Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Power BI, DAX, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more