Merge with MS Word

  • Thread starter Thread starter WG
  • Start date Start date
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?
 
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
(e-mail address removed)
 
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
 
<< 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
 
Back
Top