Mail Merge with Access 2002

[Carolyn]

I have an Access database that I am merging into a word document. My problem
is that my percentages do not want to merge correctly I enter in 5%, for
example, as .05 into Access, but when it merges into word, it displays as
5.0000000000000003E-2. I have read previous posts, visited suggested
websites, and read related articles, but have had no luck fixing my problem.
I entered *100\#"0%" into the toggle field, and played around with other
things as well, but the numbers displayed are not what I need. What do I do
to get my 5% to display as 5%? Thanks for your help.

 

[Peter Jamieson]

I entered *100\#"0%" into the toggle field

OK, *100#"0%" probably wouldn't be enough.

You would at least need to use

{ ={ MERGEFIELD myfield }*100 } /#"0%" }

where each pair of {} is entered using ctrl-F9

The other approach is to create a query in Access that does the conversion
using vba functions (I don't have code to hand, but can probably work it out
if necessary) and returns the result as a string. Then use that query as the
data source.

Peter Jamieson

 

[Carolyn]

Thanks for the suggestions. I entered in {={MERGEFIELD my field}*100}/#"0%"}
but the result was always a syntax error. Finally, I came up with
{={MERGEFIELD my field}*100\#"#%"}, and that worked for one field. I went
to another field, and it came up as syntax error again. I don't understand
why it would work for one field, and not another, but thats what is going on
now. I think your idea of a query may be the thing to do. I am not very
familiar with how to do that, but I will look it up in my book. If you have
an other suggestions, I am all ears. Thank you so much for all of your help.

 

[Carolyn]

The answer is: {={ MERGEFIELD_"myfield"} *100\#"#%"}
where _= space between fields

just for those of you who have had my problem. this will make your percent
fields appear as percents from Access.