merge % from Access to Word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Puzzled Peter - 21 Apr 2006 17:25 GMT

I am using Word 2003 and Access 2003, and want to use % values in a table as
merged fields in a word document. Using switches, I can get the % sign and
suppress the (occasional) weird non significant digit about 10 places after
the deimal point, but I cannot convert the stored value ( which is expressed
as fraction of 1) to a whole number. For example, 25% is stored in Access as
0.25 ( design format double and 2 decimals) but in the table view is shown as
25.00%. The data was origianlly appended from an Excel spreadsheet - believed
to be Excel 2003, but I am not sure.

Reply to this Message

macropod - 22 Apr 2006 07:36 GMT

Hi Peter,

Try embedding your MERGEFIELD in a formula field coded as:
{={MERGEFIELD MyData}*100 \# ,0.00%}
replacing 'MyData' with your field name and changing the number of decimal
places in the numeric picture switch (i.e. \# ,0.00%) to suit your
requirements.

Cheers

> I am using Word 2003 and Access 2003, and want to use % values in a table as
> merged fields in a word document. Using switches, I can get the % sign and
[quoted text clipped - 4 lines]
> 25.00%. The data was origianlly appended from an Excel spreadsheet - believed
> to be Excel 2003, but I am not sure.

Reply to this Message