Problem Transferring Query to Word Merge (2000)

Topic

New Reply

I have a query that has a field that calculates the Total Due. I have formatted it to be Standard, with 2 Decimal Places. But when I merge the document into Word, it is with no decimal places. (e.g. 18.40 merged is 18.4, or 40.00 merged is 40). Is there any way to have it keep the format when I merge it?

Reply | Quote

Replies

You should format the merged field in the word document.

Reply | Quote

For some reason I’m having a complete brain blockage! How do I format the number in Word? I can’t seem to find anywhere where it formats numbers.

Reply | Quote

Use something like :
{ MERGEFIELD YourField # #,##0.00 }
In the index of the help in word type : Field
Scroll down to Field codes: MergeField field
You can click on the little arrow after For more information to go to General Switches
There you can choose between the different type of fields.

Reply | Quote

Wow, I learn something new every day! Thanks, Francois.

Reply | Quote