is there an equivalent for SQL group by rollup in MS Access?

Question

The gist of GROUP BY ROLLUP is that if you group by multiple columns you will also see aggregates as if grouped by subsets of these columns.

is there a function in Access that does the same thing?

user_7296893 · Answer

Nope.

You can, however, use multiple queries and UNION ALL if you want totals/subtotals.