I once told a client how easy it is to make reports in Access. Since then, he's developed a savant-like ability to ask for reports that I find nearly impossible to do quickly and easily. Here is yet another example.

There's a report listing sales by inventory category. At the end of this report, there is a recap that groups and totals the categories by Group and sub-group. There are 4 sub-groups in 2 broad groups, so this recap shows...