Merge with MS Word

W

WG

I am merging my location field from Access with Word. In Access, I have the
location filed look the location to a separate table then store the locations
as a number to the corresponding location. In Word, I would like the
location names to show instead of the numbers. How would I best accomplish
this?
 
S

Steve

Create a query that includes the table you are working with and the location
table. Include the name of the location from the location table in the
query. Merge the query with Word rather than your working table.

Steve
[email protected]
 
J

John Spencer

Add the field that contains the name to the fields selected.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
S

Steve

<< Include the name of the location from the location table in the query. >>

When you merge, merge the location field and not the LocationID field.

Steve
 
Top