mailmerge switch problem

[darren via OfficeKB.com]

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

 

[Peter Jamieson]

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

 

[Doug Robbins - Word MVP]

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

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

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