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
(e-mail address removed)
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a query to merge records with two fields as criteria 1
Inventory transaction table - set up 5
Merge multiple records in a field, based on criteria? 2
this might be about linking tables 6
Word Word merge from Access 2007 to Word 2007 brings over PK value and not text value. 0
Update Query 1
MS Access - Form - Upload document to Sharepoint Server (whoes folder is mapped to my PC) from Acce 0
Modify existing table for more details? 8

Top