Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merge Access 'formula field' to Word
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merge Access 'formula field' to Word
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" wrote in message ... 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 |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merge Access 'formula field' to 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! "Peter Jamieson" wrote: 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" wrote in message ... 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 |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merge Access 'formula field' to Word
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] ------------------------- "Misterblanks" wrote in message ... 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! "Peter Jamieson" wrote: 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" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create formula using a merge field | Microsoft Word Help | |||
Number format wrong when using a formula in merge field | Mailmerge | |||
Merge field delimiter in insert field formula ? | Mailmerge | |||
Can an OLE Data type field from an Access table merge into Word | Mailmerge | |||
Access currency field wont format correctly in word mail merge | Mailmerge |