Mail Merge with Access 2002

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carolyn - 18 Jul 2005 17:18 GMT

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.

Reply to this Message

Peter Jamieson - 18 Jul 2005 21:04 GMT

> 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

>I have an Access database that I am merging into a word document. My
>problem
[quoted text clipped - 7 lines]
> do
> to get my 5% to display as 5%? Thanks for your help.

Reply to this Message

Carolyn - 20 Jul 2005 16:38 GMT

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.

> > I entered *100\#"0%" into the toggle field
>
[quoted text clipped - 24 lines]
> > do
> > to get my 5% to display as 5%? Thanks for your help.

Reply to this Message

Carolyn - 21 Jul 2005 20:58 GMT

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.

> 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
[quoted text clipped - 33 lines]
> > > do
> > > to get my 5% to display as 5%? Thanks for your help.

Reply to this Message