Re: formatting numeric data from Access merged into a Word table

With a night's sleep, I can quit making mac threats to myself.

"Heaven knows why" tells me there's a cleaner way to do this whole thing.
Please let me itterate what you said, since this document has not been
published yet. The cleaner it is, the easier it will be for someone else to
understand when the church uses it in future surveys (that's what this query
is; percentages of survey results;no currency).

Are you saying that Field Properties is not the best way to prepare query
values for merge fields? Would the cleanest way be to take the raw
".23984879459403" into the merge document, then use switches to make it
pretty?

These values are merged into a table created in Word. Is there a way to
select and format the switches for all of these values in the table (90 of
them) with one command?

If not, does Excel bring over Field Properties from Access? If so, would it
be possible to get the data from Access to Excel, then insert the Excel table
into the Word document with Special Paste? Would that be very unclean and
cumbersome?

Thanks in advance (again).
"macropod" wrote:

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

--
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.


"Shannon" <Shannon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:84AE6C75-72FD-4915-94D5-A720B4BB27EF@xxxxxxxxxxxxxxxx
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
re-do all that in Word? I had to do that for each field, because I when I
selected more than one field in the query, it took away the format
options.
It took a long time.

Now, will I have to make these switch changes in the table in Word
individually? I've never used one, but this nonsense makes me want to
switch
to a mac. Please tell me how to cluster or select all the inserted fields
I
want and "switdh" them all in one command.

Shannon

"Doug Robbins" wrote:

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm


--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a
paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"LacieMoon" <LacieMoon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:253C5209-A9C7-47AE-A7EE-A74B6A6A66D1@xxxxxxxxxxxxxxxx
Greetings! I have created a very simple merge from a query in Access
that
merges into a table in Word. The problem is a field defined as
currency in
Access does not "carry over" the formatting into the Word document. I
can
put
a dollar sign in front of the field $<<Amount>> but I am dealing with
large
numbers and need the comma separators. Does anyone know how I can
carry
over
the currency formatting from Access, OR correctly format the data
field in
the Word table?
Thanks for any suggestions, Lacie






.

Relevant Pages

  • Re: formatting numeric data from Access merged into a Word table
    ... mergefield in you mailmerge template. ... delete everything between 'MyData' and the closing field brace ... selected more than one field in the query, it took away the format ... will I have to make these switch changes in the table in Word ...
    (microsoft.public.word.mailmerge.fields)
  • Re: formatting numeric data from Access merged into a Word table
    ... You can simplify the updating process by toggling field code display on, ... you needed only to add the picture switch or introduce the extra field ... mergefield in you mailmerge template. ... delete everything between 'MyData' and the closing field brace ...
    (microsoft.public.word.mailmerge.fields)
  • Re: formatting numeric data from Access merged into a Word table
    ... all you need to do is to add a picture switch to the ... mergefield in you mailmerge template. ... delete everything between 'MyData' and the closing field brace ...
    (microsoft.public.word.mailmerge.fields)
  • Re: stereo amp cleaning
    ... lubricating cleaner makes all go smoothly. ... plus a switch to reverse the channels between pre-ampandamp. ... giant expensive output transistors. ... one that's off or b) start swapping electrolytic capacitors from channel to ...
    (sci.electronics.repair)
  • Re: Hissing TV.
    ... So how do I make it work from cold, ie no blurred picture. ... It is when it has been switch on after a long period off that it is ... I guess the only action I can take is to clean it throughly. ... you use a water based cleaner. ...
    (sci.electronics.repair)
Loading