Merging lookup fields in Word (1 Viewer)

S

sistagg

Guest
Hi.
I am trying to merge fields into a Word document. The fields are all lookup fields (about 150 of them in one table....don't ask!) and they all look thier data up from one table. I tried creating a query with 150 instances of the same table in it but Access seemed not to be able to cope. The fields all appear as numbers in Word but they are looking up text. Can I get the text into Word?
Cheers Si
 
S

sistagg

Guest
Easy when you know how!

Found out for myself - sorry but this might be useful for others.

If you remove any relationships the table has, you can turn the field from a number field into a text field. It will then store the textual value of the lookup. (You need to be in design for the table to do this.)

Once the field is a text lookup field then Word can access the text it is looking up!

Cheers, Si
 

Users who are viewing this thread

Top Bottom