Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mailmerge switch problem
Hi
I have a mailmerge from an access db and have a problem. The value of a field £698.40 in a currency field in the database. When I merge to word the value is the same. However, ..... when I apply a switch to format the value as currency { MERGEFIELD ProcFee \# "£##,###.00" } I end up with £702.00 ?! At present I only seem to have this issue with the one field though there are other currency fields that get merged and formatted as currency. How can I get it to show the correct value of £698.40? Thanks -- Darren Message posted via http://www.officekb.com |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mailmerge switch problem
Are the other columns definitely Currency type columns, or are they
"Double" type columns with currency formatting? As far as I know, the only fixes for this are a. change the data type in Access or b. use a query to do explicit type conversion, and use the query as the data sourcefor the merge, e.g. SELECT *,cdbl(myamount) As [myamount2] FROM mytable Peter Jamieson http://tips.pjmsn.me.uk darren via OfficeKB.com wrote: Hi I have a mailmerge from an access db and have a problem. The value of a field £698.40 in a currency field in the database. When I merge to word the value is the same. However, ..... when I apply a switch to format the value as currency { MERGEFIELD ProcFee \# "£##,###.00" } I end up with £702.00 ?! At present I only seem to have this issue with the one field though there are other currency fields that get merged and formatted as currency. How can I get it to show the correct value of £698.40? Thanks |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mailmerge switch problem
In addition to Peter's suggestion for the content of the Access Query, also
use the Access Format function to apply the Currency formatting and output the result as text. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Peter Jamieson" wrote in message ... Are the other columns definitely Currency type columns, or are they "Double" type columns with currency formatting? As far as I know, the only fixes for this are a. change the data type in Access or b. use a query to do explicit type conversion, and use the query as the data sourcefor the merge, e.g. SELECT *,cdbl(myamount) As [myamount2] FROM mytable Peter Jamieson http://tips.pjmsn.me.uk darren via OfficeKB.com wrote: Hi I have a mailmerge from an access db and have a problem. The value of a field £698.40 in a currency field in the database. When I merge to word the value is the same. However, ..... when I apply a switch to format the value as currency { MERGEFIELD ProcFee \# "£##,###.00" } I end up with £702.00 ?! At present I only seem to have this issue with the one field though there are other currency fields that get merged and formatted as currency. How can I get it to show the correct value of £698.40? Thanks |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Having a problem with a the TOC Field switch \b | Page Layout | |||
Mailmerge problem! | Mailmerge | |||
\d switch not honoured in Word 2007 mailmerge to email -MS CRM | Mailmerge | |||
Problem with numeric picture switch in mail merge | Mailmerge | |||
Problem using simple field Switch | Mailmerge |