Software

Ask something
Discussion Locked

Working Access querry yeilds wrong values in Word

0 helpful
3 replies

by rico898

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

3 replies

by atcollege

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.

by rico898

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

This discussion is closed to new replies.