merge Access 'formula field' to Word

[Misterblanks]

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

 

[Peter Jamieson]

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

 

[Misterblanks]

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?

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)
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

 

[macropod]

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

--
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!

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)
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