Normal Topic Formatting Money Fields in Merge Documents (Read 2491 times)
Mortbuy
Member
*
Offline


I'm certain I can fly

Posts: 2
Location: Ocala, Florida
Joined: Mar 20th, 2005
Formatting Money Fields in Merge Documents
Mar 20th, 2005 at 5:55am
Print Post Print Post  
When performing a merge print to MS Word 2002 money fields show up on merged document having no commas, no Dollar sign and six decimal places.

ie "25000.000000" instead of the desired "$25,000.00"

I can live with/work around the dollar sign and comma problem but need to truncate the 4 extra zeros on the end.

I am exporting to a .txt file as instructed in the manual and using the .txt file to link to Word for the merge. The extra zeros and lack of comma & dollar sign show up in the .txt file so I assume the fix lies in the process before it gets to word.

Can anyone tell me how to get rid of the extra zeros?

Help is much appreciated.

Warm regards to all
Steve
  

DOS and Q & A worked so well. Why do we need Bill Gates and his useless Windows?
Back to top
 
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Formatting Money Fields in Merge Documents
Reply #1 - Mar 20th, 2005 at 7:15am
Print Post Print Post  
Accept the value sent from Sesame and use Word to format the field.

Go to the field in Word and set the format for that field to Money..  See the Word Help secition on MergeFormat. 

You may need to toggle the Field View to see the Format code vs. the field name.

Try following these steps: 
-----------------------------------
1.  Open your Word merge document.

2.  Click on the field and press Shift F9, or press Alt F9 to toggle thel field code. This wil show the field code rather than the value.

3.  Click at the end of the field code and add the formatting code for currency.  For example, to format Price:

4.  Change FROM:
{MERGEfield Price}
TO:
{MERGEfield Price  \#$#,###.00}
--------------------------------------------------

This should have Price show up as $  $25,000.00

Also see Sesame Programming Guide pages 278,279.
  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
Mortbuy
Member
*
Offline


I'm certain I can fly

Posts: 2
Location: Ocala, Florida
Joined: Mar 20th, 2005
Re: Formatting Money Fields in Merge Documents
Reply #2 - Mar 21st, 2005 at 3:55pm
Print Post Print Post  
Thanks for the quick reply Bob. All is working well for now. Too bad Sesame doesn't have a simple integrated word processor like Q&A for us non-techie types.
Steve
  

DOS and Q & A worked so well. Why do we need Bill Gates and his useless Windows?
Back to top
 
IP Logged