General discussion
January 6, 2006 at 10:04 PM
rico898

Working Access querry yeilds wrong values in Word

by rico898 . Updated 20 years, 9 months ago

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

This discussion is locked

All Comments