Multi-valued field query

[Merge user]

I'm using Word 2007 Mail Merge with Access 2007 data source (DDE). One
of the fields merged is a multivalued lookup field. The Access database is
linked to a Sharepoint List, so I can't get rid of the multivalued lookup
field.

The data displayed in the merge are the code values for lookup fields
and not the display values. I have created a query that returns the display
values for single value lookup fields.
How can you easily query the multivalued lookup field to get the display
values (comma delimited) in a column for each row?

Thanks

 

[Merge user]

I haven't had a response so I'm wondering if my question is unclear or you
need more information.

Basically I have created a query that returns the display value for
single-value lookup columns.
I need to also return the display value (as a single comma delimited column
for the row) for multi-column lookup columns but I don't know how to do this
in a query.

Thanks

 

[Merge user]

I haven't had a response so I'm wondering if my post is unclear or you
need more information.

Bascially I have a created a query that returns the display value for
single-value lookup columns for a row. I also need to return the display
values (in a single column with display values comma delimited) for
multi-value lookup columns for the row. How can you do this in a query?

Thanks