Mail Merge from Access Query

[Baldeagle]

I have set up a Word document which draws its information from an Access Query. The Query has a calculated field - Tax: CCur(Int((((Int(((100*[Total Paid]/(100-[Rate of Tax]))*100)+0.5)/100)+0.01))*[Rate of Tax])/100). The ouput of this query is currency and includes any final zeros (eg $120.50). But when I insert this field into the mail merge document it loses any final zeros. How can I hold the proper format in the mail merge document?

[RuralGuy]

Try wrapping your function in a Format() function.

[Baldeagle]

Try wrapping your function in a Format() function.

Thanks for the suggestion but could you please be a little more explicit? I'm not an expert and don't understand what you mean. Where do I use the Format() function? In my Query in Access? If so how? Or in the Word document? I would appreciate a little bit more guidance.

[RuralGuy]

Try:
Tax: Format(CCur(Int((((Int(((100*[Total Paid]/(100-[Rate of Tax]))*100)+0.5)/100)+0.01))*[Rate of Tax])/100),"$###,##0.00")

[Baldeagle]

Try:
Tax: Format(CCur(Int((((Int(((100*[Total Paid]/(100-[Rate of Tax]))*100)+0.5)/100)+0.01))*[Rate of Tax])/100),"$###,##0.00")

Brilliant. That does exactly what I want. Many thanks.

[RuralGuy]

Great! Glad we could help.