Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Bogus Mail Merge Results
After merging a query from MS Access 2003 to MS Word 2003 I get the auto
number from the table that is a lookup for another table. The query shows the correct information but the merge results in the auto number associated with the correct information. Any help is much appreciated! |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Bogus Mail Merge Results
Can you tell us what the SQL for your query is? Does it just select all the
fields in the table that references the lookup? If so, you probably need to do an explicit join with the lookup table, e.g. instead of SELECT x.* FROM tablex x ? try SELECT x.*, y.* FROM tablex x INNER JOIN tabley y ON x.lookupIDfield = y.lookupIDfield or the old-fashioned way SELECT x.*, y.* FROM tablex x, tabley y WHERE x.lookupIDfield = y.lookupIDfield I don't know if that wil fix the problem but it's probably what I would try in the first instance. Peter Jamieson "workliveplay" wrote in message ... After merging a query from MS Access 2003 to MS Word 2003 I get the auto number from the table that is a lookup for another table. The query shows the correct information but the merge results in the auto number associated with the correct information. Any help is much appreciated! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I mail merge to EMAIL from MS Word AND add a pdf attachment | Mailmerge | |||
printing difficultiies using mail merge in word | Mailmerge | |||
how smart can a word 2003 mail merge letter be? | Mailmerge | |||
Heavy Mail Merge Application | Mailmerge | |||
How to get all mail merge fields in a document | Mailmerge |