Grouping query results

[mixup]

I have a select query from a few related tables, one relationship being many-to-many. The resulting query, when run would have several groups of records where each group has all but one field different (a text field). Is it possible to do a report where this group appears as one record with the results of that field as a list?

 

[boblarson]

Yes, use groupings on the report for everything and use a sub report for the detail section.

 

[mixup]

Bob: Thanks a lot. That should do it.