Mail Merge Currency from Access Query

[DiTab1]

I have a problem. When I merge my Currency (format in Access) field to my
Word document I get one of two problems depending on my switch. Please do
not refer me to G Mayor website. I have been there and it did not solve my
problem.

If I do not put in a switch and merge just as the field itself I get the
following:
Data in Access: $141.30 Data in Word: 141 3

If I use the switch /# ##,###.00
Data in Access: $141.30 Data in Word 144.00

For some reason if the cents in the currency is X0 then it adds the last
dollar number and the first cents number together. If the cents is XX then
it imports fine.

I know that I can get "around" this by changing the field type in access to
text but I need it to remain currency for my formulas in my access reports to
work.

Please help....

~Di

 

[DiTab1]

I know... I'm replying to my own post but I found this fix and I hope it will
be helpful to someone else... Thank you to:
http://homepage.swissonline.ch/cindymeister/mergfaq.htm#NumFormat for giving
me a jumping off point!!

In my Access Query I added the following:

PaidAM: Format([Amount Owed],"#,###.00")

Then I used th PaidAM as my merge field. Works like a charm!!!

I'm off to find a wig to cover my new bald spot from pulling out my hair!
<grin>

~Di