For the currency, all you need to do is to add a picture switch to the
mergefield in you mailmerge template. To do this:
. select the mergefield
. press Shift-F9 to expose the field code. It should look something like
'{MERGEFIELD MyData}', where 'MyData' is your data field's name
. delete everything between 'MyData' and the closing field brace
. add ' \# $,0.00' after 'MyData', so that you end up with '{MERGEFIELD
MyData \# $,0.00}'
. press F9 to update the field
. run your mailmerge.
However, if you've already converted the values to percentages in Access
(heaven knows why), you can recover this in Word with just a little bit more
work. In addition to the above, before updating the field:
. select the 'MERGEFIELD MyData' string in your mergefield
. press Ctrl-F9 to insert a new pair of field braces, so that you get
'{{MERGEFIELD MyData} \# $,0.00}'
. insert an '=' sign between the first two field braces and '*100' after the
third field brace, so that you get '{={MERGEFIELD MyData}*100 \# $,0.00}'
Cheers

Signature
macropod
[MVP - Microsoft Word]
PS: If you want $ without cents, make the picture switch '\# $,0'
PPS: Switching to a Mac would make no difference - the same situation
applies there too.
> So, did I just take off the "100*" and format all 90 fields to be percentages
> with 0 decimals in Access for naught? Are you saying I'm going to have to
[quoted text clipped - 25 lines]
> > > the Word table?
> > > Thanks for any suggestions, Lacie