By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,240 Members | 782 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,240 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.