Is there a way I can use a query combine all the names into a single "virtual" field, so that I only have one row for each address?

Here is what I would like to see!

First its not a good idea to piggyback your question on someone else's. This can lead to confusion. You should start a new thread. So I've moved your question to its own thread.

Yes you can do this. The function found here Access Help and How-to - Microsoft Office Code To Concatenate Multiple Records Into A Single Field - UtterAccess Discussion Forums will combine fields from multiple records in a group into one column of a query.