how to export multiple value field to excel

Hi I'm learning Access by myself and i have some problem with exporting a multiple value field to an excel. Hope someone can help.

I have a field name "Users" in a table wherein this field is a multiple value field and looku up the value from the other table. When I export the table to excel, the data in the multiple value field does not export properly and it just shows some symbol in the excel.

Is there something wrong with my field?

The general advice is
- DO NOT USE MULTI-VALUED FIELDS
- Do NOT USE LOOKUPS AT THE TABLE LEVEL

These concepts/facilities are proving to be extremely confusing and of limited use at the very best. They may even violate relational design principles.

I would have to agree with jdraw.

Just don't use lookups at the Table level. It is fine to use them in a Form, but NEVER in a Table.