Query Compression?

[matt_maier]

Suppose I have a Access database with a single table. The table has two fields not counting the key: Room and Furniture. The Table is organized somewhat like this:

 
Room            Furniture
Living Room     Table
Living Room     Chair
Living Room     Sofa
Dining Room     Plant

Is there any way to make a query or report that generates an output like this into two fields?

 
Room            Furniture 
Living Room     Table,Sofa,Chair
Dining Room     Plant

Thanks for any help you can provide!