Bogus Mail Merge Results

[workliveplay]

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!

 

[Peter Jamieson]

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