Group by field

[mordecai98]

I have a report made from a query that includes a list of campers names and their group from one table and group and counselor from another table. I want to create a report that will include each group and counselor in the header and then a list of campers. Can it be done so one report will do this for all the groups, or one report for each group?

Do I need to structure the query differently? Here is the query, query design and the report.

[AlexHedley]

There's Grouping and Sorting options on the bottom of the Report, if not you might have to toggle them on from the Ribbon.
Add a Group By then drag the Counsellor into that Group.

Tips
http://www.599cd.com/tips/access/130...?key=AlexForum

http://www.599cd.com/tips/access/sor...?key=AlexForum

http://www.599cd.com/tips/access/rep...?key=AlexForum

[azhar2006]

Thank you very much Alex Hedley
The subject of a very wonderful
Thanks again Alex Hedley
Is it possible to set an example DB