Getting currency to appear in mail merge from fields made in query

[Tom Keane]

Hi, I need some helpings again!

I have a query from one of my tables that gets a total amount of money and
gets a percentage from it

ie, the field I create in the query is invGSTAmount from a field in my table
called invAmount, so I but in the design view of my query:

invGSTAmount: [invAmount]*1/11

Now, I merge these two fields into MS Word. The field, invAmount merges with
all the formatting it's supposed to (currency), but when I merge the
invGSTAmount it just throws in a stupid number without all the currency
formatting.

Is there a way I can get around this? Normally I would just chuck a "$" and
a ".00" around it, but there are tonnes of prices I'm dealing with that use
the cents thingy.

Help is appreciated as always ;)
Tom Keane

[Allen Browne]

Right-click the merge field Word. You should be able to format it as
currency there.

If you can't sort it out in Word, you can explicitly format the data in the
query in Access. The field is then text, and the query therefore exports the
desired text to Word. The calculated query field would be:
invGSTAmount: Format([invAmount]*1/11, "Currency")

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Tom Keane" <ol*******@sillysillyspamyahoo.com> wrote in message
news:hJ******************@news-server.bigpond.net.au...

Hi, I need some helpings again!

I have a query from one of my tables that gets a total amount of money and
gets a percentage from it

ie, the field I create in the query is invGSTAmount from a field in my
table
called invAmount, so I but in the design view of my query:

invGSTAmount: [invAmount]*1/11

Now, I merge these two fields into MS Word. The field, invAmount merges
with
all the formatting it's supposed to (currency), but when I merge the
invGSTAmount it just throws in a stupid number without all the currency
formatting.

Is there a way I can get around this? Normally I would just chuck a "$"
and
a ".00" around it, but there are tonnes of prices I'm dealing with that
use
the cents thingy.

Help is appreciated as always ;)
Tom Keane