Reply
 
Thread Tools Display Modes
  #1   Report Post  
LacieMoon
 
Posts: n/a
Default formatting numeric data from Access merged into a Word table

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
  #2   Report Post  
Doug Robbins
 
Posts: n/a
Default

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" wrote in message
...
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



  #3   Report Post  
LacieMoon
 
Posts: n/a
Default

Perfect Doug! Worked like a charm; thank you for directing me to a great
resource!
Lacie

"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" wrote in message
...
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




  #4   Report Post  
KarenABS
 
Posts: n/a
Default formatting numeric data from Access merged into a Word table

Thanks so much for this information!

"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" wrote in message
...
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




  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Shannon Shannon is offline
external usenet poster
 
Posts: 42
Default formatting numeric data from Access merged into a Word table

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" wrote in message
...
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






  #6   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod macropod is offline
external usenet poster
 
Posts: 1,002
Default formatting numeric data from Access merged into a Word table

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" wrote in message
...
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" wrote in message
...
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






  #7   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Shannon Shannon is offline
external usenet poster
 
Posts: 42
Default 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" wrote in message
...
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" wrote in message
...
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






  #8   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default formatting numeric data from Access merged into a Word table

Word merge imports the raw data, so formatting it doesn't help much. See
http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Shannon wrote:
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" wrote in message
...
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" wrote in message
...
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



  #9   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default formatting numeric data from Access merged into a Word table

Just a suggestion...

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


Every time you connect to Access data from Word there is some translation,
which implies that you may need to reformat the data the way you want in
Word. If you are inserting the data using mailmerge and { MERGEFIELD }
fields then you have the options to format them that have been suggested by
others. If you are inserting the data using Insert|Database then you have
less control over the format of each column.

Personally in trying to achieve a "clean" approach I would typically try to
opt for a "repeatable" approach and that would probably rely on a
combination of using the right data types in Access and applying the right
switches to MERGEFIELD fields in Word, or using a query to return /exactly/
the data I needed (e.g. if it should be a percentage value with a percent
sign at the end, return that as a string value and Word should not
re-interpret it as a number).

However, another approach that may work in your siuation if you do not have
need more columns than the maximum no. in a Word table is
a. write a query in Access so that the query returns the data you need, in
the format you need
b. select the query results in Access and Edit|Copy
c. Edit|Paste into a blank Word document
d. remove the top row
e. use that as the data source for a merge (or, if appropriate, insert the
table directly into the document you're trying to produce, then format it
using a simple macro).

Just my 2-c worth.

Peter Jamieson
"Shannon" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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








  #10   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Shannon Shannon is offline
external usenet poster
 
Posts: 42
Default formatting numeric data from Access merged into a Word table

Does that mean the whole 'Excel' idea is a bad one?

"Graham Mayor" wrote:

Word merge imports the raw data, so formatting it doesn't help much. See
http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Shannon wrote:
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" wrote in message
...
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" wrote in message
...
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






  #11   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Shannon Shannon is offline
external usenet poster
 
Posts: 42
Default formatting numeric data from Access merged into a Word table

Macropod's suggestion is working. Thanks. It's just a pain to do this 90
times. Someone else prepared the Word survey with tables already set up,
otherwise, I could copy and paste the codes. Actually, I could have done
that this time, if I had not already entered all the field names into the
table.

"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" wrote in message
...
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" wrote in message
...
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






  #12   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod macropod is offline
external usenet poster
 
Posts: 1,002
Default formatting numeric data from Access merged into a Word table

Hi Shannon,

You can simplify the updating process by toggling field code display on, via
Alt-F9, then using Copy/Paste to replicate the changes. Depending on whether
you needed only to add the picture switch or introduce the extra field
coding, it may be easier to copy & paste:
.. the field switch to all affected fields; or
.. a single recoded field to all required locations, then update the field
names

Cheers

--
macropod
[MVP - Microsoft Word]


"Shannon" wrote in message
...
Macropod's suggestion is working. Thanks. It's just a pain to do this 90
times. Someone else prepared the Word survey with tables already set up,
otherwise, I could copy and paste the codes. Actually, I could have done
that this time, if I had not already entered all the field names into the
table.

"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" wrote in message
...
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" wrote in message
...
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








Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I insert Excel data as a Word table and stay within margins Fritz Tables 1 February 6th 05 09:39 AM
Boiletplates from Word Perfect linda Microsoft Word Help 1 January 28th 05 06:37 PM
How do I create & merge specific data base & master documents? maggiev New Users 2 January 13th 05 12:30 AM
In typing dates in Word, i.e. "January 12" how do you keep the "1. Carol Microsoft Word Help 2 January 12th 05 09:09 PM
formatting links from excel into word (extra line feeds) JGT Microsoft Word Help 1 December 9th 04 12:01 PM


All times are GMT +1. The time now is 03:26 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"