Re: Mail Merge with Access 2002

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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.



"Peter Jamieson" wrote:

> > 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" <Carolyn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:45B79094-5670-48DC-A83D-625762BA0C89@xxxxxxxxxxxxxxxx
> >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.
>
>
>
.

Relevant Pages

  • Re: Set a field before running query
    ... Peter Jamieson wrote: ... put it in any module in the document or the template it is attached to - use AutoNew if it's in a template, ... To build the SQL, look at your query. ... Word document, that's OK. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Mailmerge from Access
    ... Sorry but I didnt realise you had replied. ... Peter Jamieson wrote in message ... >> specifically directs you to open a word document, ... >> introduce a parameter into the MS query. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Word 2007 mailmerge from Access 2007
    ... "Peter Jamieson" wrote: ... The word document can be opened ... retrieve the data created by the query. ... seems to not keep the connection between the two applications. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Set a field before running query
    ... Peter, I would like to use the VBA approach, but I'm not sure how ... Peter Jamieson wrote: ... correct SQL or to EXECUTE the parameter query and pass the parameter you want, and possibly a couple of other approaches. ... Word document, that's OK. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: MailMerge hangs and crashes with Access on Server
    ... Since I am fairly new to working in this environment, I am not sure what you mean by an "Access group" with help to restructuring the query? ... "Peter Jamieson" wrote: ... All I know is that the performance of queries depends to a large extent on whether, for example, a join is performed on the client side, or on the server side, incurring no network traffic and potentially benefitting from caching on the server. ... There are no dialog boxes, and actually, I have now split the database, and have kept the Word templates and the Access frontend locally on my machine, and moved the backend to the server. ...
    (microsoft.public.word.mailmerge.fields)