Mail Merge Currency from Access Query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DiTab1 - 02 Feb 2006 17:09 GMT

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

Reply to this Message

DiTab1 - 02 Feb 2006 18:16 GMT

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

> 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
[quoted text clipped - 19 lines]
>
> ~Di

Reply to this Message