Merging information from a table into a Microsoft Word Document

  • Thread starter Thread starter Needing Access
  • Start date Start date
N

Needing Access

This is an Access question. I have a table of information I need to merge
into a Word Doc. For easier dataentry I have used drop down tables for
things like states and people's names. When I merge using the field name the
information displays as a number. I'm getting the ID number instead of the
item from the drop down that I selected. I'm using version 2007.

I hope my explanation was clear enough. Any suggestions?
 
If you created the "drop downs" via the Lookup Wizard in your table design
then, most likely, you left the "hide primary key" checkbox checked. Thus,
while you are actually storing the value of the primary key in the table that
you are trying to export, you see the text value of the state or the number.
This is one of the drawbacks of using the Lookup Wizard in table design.

You will need to create a query that includes the text values from the
lookup table and export the results of that query to word.
 
Thank you. That helps. I'm off to learn how to use Queries.
It's good to have a new learning experience!
Thanks.
 
Back
Top