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?

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

Bob: Thanks a lot. That should do it.