Query Design Microsoft Access 2007

mmcgillo88 used Ask the Experts™
I have a query in Access and items are listed by "Department" (left most column) -- and say there is Department A, B, C. I want the subtotals by department to be listed under each section in the column. Currently it is sorted alphabetically.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016

post the query you are using now
post an image of the result you are getting
You cannot do that in a single query.
EIther you show the detail OR you show department totals.  You can't do both in a single query.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial