[Peter Jamieson]

Try

[ColFee]: Format([Account Information]![Col#]*0.65,"$#,###.00")

Peter Jamieson

http://tips.pjmsn.me.uk

On 12/01/2010 17:13, Chris wrote:
Thanks Doug,

That does clarify it a bit. I am trying to do this now. I should note that
this is a calculated query field in Access 2007 and the expression now looks
like this:

Format([ColFee],"$#,###.00"): ([Account Information]![Col#]*0.65)

where formaerly it looked like this:

[ColFee]: ([Account Information]![Col#]*0.65)

There is apparently a syntax error in the calculated field. Any ideas?

Thanks, Chris

"Doug Robbins - Word MVP" wrote:

Exactly how did you apply the Format() function in Access

What I meant was to use Format([ColFee],"$#,###.00") in a query. Not to
format the field type in the Table Design as Currency as that only dictates
how the data is displayed in Access and not how it is stored.

Using the Format() function converts the numeric data to text so that no
format switch is required when the data from a query is used in mail merge.



--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.

wrote in message
...
Hello Doug,

Sorry for the lateness of the reply but it seems the postings were not
being
listed until just now.

The ommission of the \* was a typo on my part in the original posting - it
was not ommitted in the Word file. My apologies. Changing the Field
switch
and updating always resulted in an error. I did in fact also format the
field in the Access file as Currency (2 decimal places), but that had no
effect either. Because it was not working I ended up saving the Word file
and the Access files in 2003 formats. This did work.

I am beginning to think that there are some issues here that need to be
sorted out my Microsoft.

"Doug Robbins - Word MVP" wrote:

You have omitted the \#

You should be using { MERGEFIELD ColFee \# "$,#.00;($,#.00" }

Note however, if you are using the Format() function in a query in Access
to
format the currency to the way that you want it, that will convert it to
text and no further formatting will be required in Word.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

wrote in message
...
Hello,

I have been trying to insert the merge field switches to control the
appearance of data merged from Access 2007.

I am merging from an Access dbase query and I converted the fields in
Access
to Currency and 2 decimal places there first.

I went into the the Word 2007 options and turned on "Confirm file
format
conversion on open". In the Confirm Data Source dialogue box I am
selecting
MS Access Databases via DDE (*.mdb;*.mde). There is often a problem
with
this little procedure as well, but that is for a different day.

I am inserting the field switches as indicated on Graham Mayor's
website
at
http://www.gmayor.com/formatting_word_fields.htm

When I toggle the field code in Word this is what I am using:
{ MERGEFIELD ColFee "$,#.00;($,#.00" }

I have tried other methods as well but nothing seems to work.

Any help with this would be greatly appreciated. Thanks,

Chris


.


.