It's probably best to ask this by way of an example.

Let's say you have a database about a college campus. For each
building you've got information in a Building table; for each room
you've got information in a Room table.

Now let's say you want to do a report that produces the following
result:

Alpha Hall
Rooms: 101a 101b 102 103 104a 104b... etc.

Beta Hall
Rooms: 31 32 33 34 41 42 43... etc.

For each hall, the series following the "Rooms:" heading comes from a
query result, except that the listed results are separated by spaces,
with no line break in between. How can you do this?

This may seem like a simple question, and indeed I am new to Access.
For what it's worth, though, I've managed to find out the answer to
all my previous questions on my own... this is the first time I've had
to ask for help.

Greg