[AccessDevelopers] formatting numbers from a query that are merged into a Word mailmerge document.

 

Hi,
I'm using an Access 2010 query to pass data to a Word MailMerge document but have problems with number formatting.
One field is a Percent field, I enter the data as 10% but when the mailmerge runs it displays as .10000000149011612. I canmultiply the InterestRate field by 100 to get 10.000000149011612 but how can I clean up the trailing decimals (not entered into the database)?
Other fields are Currency but the mailmerge drops trailing zeros after the decimal point. How can I reformat the data in Word?
Thanks,
Capt. James Cook

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 2

Visit Your Group

Please zip all files prior to uploading to Files section.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___