Software·43,882 discussions

Working Access querry yeilds wrong values in Word

Locked

I have a large Access 2003 database which has a query involving multiple tables. Viewing the calculated values in the query shows the correct values. When this query is used for mail merge fields in a Word 2003 document it produces errors in 2 or 3 of the categories used for the calculations. THe other categories work correctly. If I export the query results to Excel and use that file for the mail merge all values are correct.

I’ve spent hours checking relationships and the underlying structure and I must be missing something simple. I can find no mathematical pattern to the erros.

Any Suggestions ?

Thanx – Rico

Topic

Reply To: Working Access querry yeilds wrong values in Word

In reply to Working Access querry yeilds wrong values in Word

In Word, have you checked confirm conversion at open? (Tools, Options, General tab,check Confirm conversion at open).
When you connect to the database in Word, select the DDE type of connection. Then the formats come across OK.
I use a query containing 9 linked tables as a recipient list in Word and it is great.

Reply To: Working Access querry yeilds wrong values in Word

In reply to Reply To: Working Access querry yeilds wrong values in Word

Although I managed to work around the problem eventually by splitting the formatted calculation into a calculation ( new field ) and then formatting it, your solution fixed the problem and IS certainly preferable.

Thanks

Reply To: Working Access querry yeilds wrong values in Word

In reply to Working Access querry yeilds wrong values in Word

This question was closed by the author

[Author]

Replies