merge Access 'formula field' to Word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Misterblanks - 10 Mar 2007 16:50 GMT

I have built an Access database. I have one simple formula in Access (2003)
where a [TotalAmountDue]-[TotalAmountPaid] gives me a Control Source named
"RemainingBalance." How do I get this Field (RemainingBalance) to display
the same result on my Word document as it shows in Access? Right now it
displays in Word as: $ 2000.00-300 but the correct <MERGEFIELD> output
should be $ 1700.00

I didn't have gray hair yesterday, now I do.

Thank you so much in advance.
Timothy J Lunde

Reply to this Message

Peter Jamieson - 10 Mar 2007 17:22 GMT

Which version of Word?

Where exactly is your formula defined, and how are you getting the data to
Word? Are you connecting to a Query? If so, can you find the underlying SQL
for the Query (e.g. open Query Design, right-click the title bar and select
SQL View) and post the SQL here.

Peter Jamieson

>I have built an Access database. I have one simple formula in Access
>(2003)
[quoted text clipped - 8 lines]
> Thank you so much in advance.
> Timothy J Lunde

Reply to this Message

Misterblanks - 10 Mar 2007 18:50 GMT

I discoverd my answer in the second line of your response. woops! data comes
from a table and the formula is on the form. (rookies, huh?) Thanks!

> Which version of Word?
>
[quoted text clipped - 17 lines]
> > Thank you so much in advance.
> > Timothy J Lunde

Reply to this Message

macropod - 11 Mar 2007 07:04 GMT

Hi Misterblanks,

In that case, you can have Word perform the same calculation in the mailmerge, without needing to create another field in your db
for the balance. To do this, embed the mailmerge fields in a formula field coded as:
{={MERGEFIELD TotalAmountDue}-{MERGEFIELD TotalAmountPaid}}
where the field braces (i.e. '{ }') are created in pairs via Ctrl-F9. If you want, you can add field 'picture' switches to control
the result's formatting.

Cheers

Signature

macropod
[MVP - Microsoft Word]
-------------------------

>I discoverd my answer in the second line of your response. woops! data comes
> from a table and the formula is on the form. (rookies, huh?) Thanks!
[quoted text clipped - 20 lines]
>> > Thank you so much in advance.
>> > Timothy J Lunde

Reply to this Message