Mail Merge - Multiple value fields

[JDCD201]

Hi Guys,
I am using mail merge to produce reports for lift inspections and it is all going well apart from the fields that are multi value do not quite transfer.

For instance the "inspections completed" field has a list of the months Jan-Dec and therefore a visit may have been completed in Jan, Mar & Jul for example.

In word the first two letter of the last month are transferred across followed by Chinese symbols.

Thanks for your help,
James

 

[jdraw]

Most people would advise you not to use multi-valued fields. You may want to review your database structure (tables and relationships) and ensure that all are properly normalized.

These links may help:
Database Principles
Entity Relationship Diagramming

Good luck.