I have a report generated from a single query, is it possible to group data within same detail section or is it possible to create multiple detail sections for each grouping?
There's really only one DETAIL section, but you can group things and make their own 'headers'. In the design view of the report, right-click in the upper-left (in the black square) or VIEW+SORTING and GROUPING from the menu. For each thing you want to Group on, enter it/pick it in the list, then down below you can set GROUP HEADER to YES. Put the text box (or other control) of that item in the HEADER it makes for you.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.