Group-Based Total Collection with ADO

An Excel file that teaches how to perform Group-Based Total Collection with ADO operation.

Excel Format: Group-Based Total Collection with Ado

GROUP BY statement is used. SUM value is obtained for each group. Summary results are collected in a single table. The report reduces the need for pivots in some cases.

Hope it is useful.