Mailmerge - Word & Access

Mailmerge - Word & Access - Incorect Data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marge - 22 Mar 2006 00:59 GMT

I am using a MS Access 2003 Query and merging into a MS Word 2003 document. I
am having trouble with three of the dozens of calculated fields I am merging.
In Access the value in the first caclulated field is 450 (Correct). In the
merged document it is -125. In access, I checked the data sheet, and the
form. Both have 450. I exported it to excel and the excel field alos shows
450. I created a new field with the same calulation in Access (Expr1) I get
the same results when I added that field to the Word Document. I finally
entered a calculation into the Word document and that provides the correct
number (450) but I really prefer to do all the calculations only in the
Access Query. Any ideas what I am doing wrong?

Signature

Marge

Reply to this Message

Doug Robbins - Word MVP - 22 Mar 2006 06:06 GMT

What is the calculation in the Query (copy and paste the SQL into a message)

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I am using a MS Access 2003 Query and merging into a MS Word 2003 document.
>I
[quoted text clipped - 11 lines]
> number (450) but I really prefer to do all the calculations only in the
> Access Query. Any ideas what I am doing wrong?

Reply to this Message

Marge - 23 Mar 2006 00:56 GMT

I still do not know what went wrong, but I did get it working. I started a
brand new document, selecting DDE, and copied the old document into the new
one. Then I reinserted the 3 mergefields that were not displaying the
correct numbers. (I also left the old ones just for comparison purposes.
The mergefields I newly inserted displayed the correct numbers, while the
same fields I copied from the old document did not.

Here is the calculation for one of the fields copied from the Build
statement: Simple.
Incentive Last Month Rent Deposit: [Standard Last Month Rent]-[Actual Last
Month Rent]

Signature

Tank you for your reply!
Marge

> What is the calculation in the Query (copy and paste the SQL into a message)
>
[quoted text clipped - 13 lines]
> > number (450) but I really prefer to do all the calculations only in the
> > Access Query. Any ideas what I am doing wrong?

Reply to this Message

Doug Robbins - Word MVP - 23 Mar 2006 06:00 GMT

I think that you are likely to get problems with field names that include
spaces - Incentive Last Month Rent Deposit

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I still do not know what went wrong, but I did get it working. I started a
> brand new document, selecting DDE, and copied the old document into the
[quoted text clipped - 32 lines]
>> > number (450) but I really prefer to do all the calculations only in the
>> > Access Query. Any ideas what I am doing wrong?

Reply to this Message