[Chris Stammers]

I need to format a currency field to be £0.00 if greater than £1 and 00p if
less than £1 in the data source. The data source holds the data as 1.00 or
..50. I have created this query: {IF { MERGEFIELD } 1 "£{MERGEFIELD\#,0.00 }
"{ MERGEFIELD\#.00 }p" }

The query does work but where there is just .50, it shows in the merge doc
with a leading decimal point. My question is this - is there a formatting
switch to get rid of the decimal point in the case where it is just pence? I
have tried taking the decimal point away and the query stops working. I tried
susbtituting the hash sign for a '@' instead and that didn't work either. Any
suggestions?

Thanks,
Chris

[Doug Robbins - Word MVP]

Multiply it by 100

{IF { MERGEFIELD } 1 "£{MERGEFIELD\#,0.00 }
"{ = { MERGEFIELD\#.00 }* 100 }p" }


--
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

"Chris Stammers" wrote in message
...
I need to format a currency field to be £0.00 if greater than £1 and 00p if
less than £1 in the data source. The data source holds the data as 1.00 or
.50. I have created this query: {IF { MERGEFIELD } 1
"£{MERGEFIELD\#,0.00 }
"{ MERGEFIELD\#.00 }p" }

The query does work but where there is just .50, it shows in the merge doc
with a leading decimal point. My question is this - is there a formatting
switch to get rid of the decimal point in the case where it is just pence?
I
have tried taking the decimal point away and the query stops working. I
tried
susbtituting the hash sign for a '@' instead and that didn't work either.
Any
suggestions?

Thanks,
Chris

[Peter Jamieson]

Try

{ IF { MERGEFIELD myamount } 0.995 "{ MERGEFIELD myamount \#£,0.00 }"
"{ ={ MERGEFIELD myamount } * 100 \#00p }

Peter Jamieson
"Chris Stammers" wrote in message
...
I need to format a currency field to be £0.00 if greater than £1 and 00p if
less than £1 in the data source. The data source holds the data as 1.00 or
.50. I have created this query: {IF { MERGEFIELD } 1
"£{MERGEFIELD\#,0.00 }
"{ MERGEFIELD\#.00 }p" }

The query does work but where there is just .50, it shows in the merge doc
with a leading decimal point. My question is this - is there a formatting
switch to get rid of the decimal point in the case where it is just pence?
I
have tried taking the decimal point away and the query stops working. I
tried
susbtituting the hash sign for a '@' instead and that didn't work either.
Any
suggestions?

Thanks,
Chris

[Chris Stammers]

Peter and Doug - Thank you.
Regards,
Chris

"Chris Stammers" wrote:

I need to format a currency field to be £0.00 if greater than £1 and 00p if
less than £1 in the data source. The data source holds the data as 1.00 or
.50. I have created this query: {IF { MERGEFIELD } 1 "£{MERGEFIELD\#,0.00 }
"{ MERGEFIELD\#.00 }p" }

The query does work but where there is just .50, it shows in the merge doc
with a leading decimal point. My question is this - is there a formatting
switch to get rid of the decimal point in the case where it is just pence? I
have tried taking the decimal point away and the query stops working. I tried
susbtituting the hash sign for a '@' instead and that didn't work either. Any
suggestions?

Thanks,
Chris

[Chris Stammers]

Hello again,

Thanks for this query. I have placed it into 2 documents. It works in one
place in one document. However it seems that when the query is converting to
pence, only part of the paragraph it is part of will generate. The pound
formatting works fine.

However, the other document I have placed it in doesn't work at all if that
query is placed in it; all I get is 'Field Calculation Error in Record 1' etc.

Any ideas?

Thanks,
Chris


"Peter Jamieson" wrote:

Try

{ IF { MERGEFIELD myamount } 0.995 "{ MERGEFIELD myamount \#£,0.00 }"
"{ ={ MERGEFIELD myamount } * 100 \#00p }

Peter Jamieson
"Chris Stammers" wrote in message
...
I need to format a currency field to be £0.00 if greater than £1 and 00p if
less than £1 in the data source. The data source holds the data as 1.00 or
.50. I have created this query: {IF { MERGEFIELD } 1
"£{MERGEFIELD\#,0.00 }
"{ MERGEFIELD\#.00 }p" }

The query does work but where there is just .50, it shows in the merge doc
with a leading decimal point. My question is this - is there a formatting
switch to get rid of the decimal point in the case where it is just pence?
I
have tried taking the decimal point away and the query stops working. I
tried
susbtituting the hash sign for a '@' instead and that didn't work either.
Any
suggestions?

Thanks,
Chris

[Peter Jamieson]

a. I've missed the closing quotes and field brace:

b. It may need quotes around the format, i.e.

{ IF { MERGEFIELD myamount } 0.995 "{ MERGEFIELD myamount \#"£,0.00" }"
"{ ={ MERGEFIELD myamount } * 100 \#"00p" }" }

If you still have trouble I suppose I would try the following next

{ IF { MERGEFIELD myamount } 0.995 "{ MERGEFIELD myamount \#"£,0.00" }"
"{ ={ MERGEFIELD myamount } * 100 \#"00" }p" }

Peter Jamieson


"Chris Stammers" wrote in message
...
Hello again,

Thanks for this query. I have placed it into 2 documents. It works in one
place in one document. However it seems that when the query is converting
to
pence, only part of the paragraph it is part of will generate. The pound
formatting works fine.

However, the other document I have placed it in doesn't work at all if
that
query is placed in it; all I get is 'Field Calculation Error in Record 1'
etc.

Any ideas?

Thanks,
Chris


"Peter Jamieson" wrote:

Try

{ IF { MERGEFIELD myamount } 0.995 "{ MERGEFIELD myamount \#£,0.00 }"
"{ ={ MERGEFIELD myamount } * 100 \#00p }

Peter Jamieson
"Chris Stammers" wrote in
message
...
I need to format a currency field to be £0.00 if greater than £1 and 00p
if
less than £1 in the data source. The data source holds the data as 1.00
or
.50. I have created this query: {IF { MERGEFIELD } 1
"£{MERGEFIELD\#,0.00 }
"{ MERGEFIELD\#.00 }p" }

The query does work but where there is just .50, it shows in the merge
doc
with a leading decimal point. My question is this - is there a
formatting
switch to get rid of the decimal point in the case where it is just
pence?
I
have tried taking the decimal point away and the query stops working. I
tried
susbtituting the hash sign for a '@' instead and that didn't work
either.
Any
suggestions?

Thanks,
Chris

[Chris Stammers]

Peter,

Many thanks. I have tried both of those options with a basic merge using a
dummy file and both seemed to work fine. I will try with the offending
documents on Monday and see what happens.
Regards,
Chris

"Chris Stammers" wrote:

Hello again,

Thanks for this query. I have placed it into 2 documents. It works in one
place in one document. However it seems that when the query is converting to
pence, only part of the paragraph it is part of will generate. The pound
formatting works fine.

However, the other document I have placed it in doesn't work at all if that
query is placed in it; all I get is 'Field Calculation Error in Record 1' etc.

Any ideas?

Thanks,
Chris


"Peter Jamieson" wrote:

Try

{ IF { MERGEFIELD myamount } 0.995 "{ MERGEFIELD myamount \#£,0.00 }"
"{ ={ MERGEFIELD myamount } * 100 \#00p }

Peter Jamieson
"Chris Stammers" wrote in message
...
I need to format a currency field to be £0.00 if greater than £1 and 00p if
less than £1 in the data source. The data source holds the data as 1.00 or
.50. I have created this query: {IF { MERGEFIELD } 1
"£{MERGEFIELD\#,0.00 }
"{ MERGEFIELD\#.00 }p" }

The query does work but where there is just .50, it shows in the merge doc
with a leading decimal point. My question is this - is there a formatting
switch to get rid of the decimal point in the case where it is just pence?
I
have tried taking the decimal point away and the query stops working. I
tried
susbtituting the hash sign for a '@' instead and that didn't work either.
Any
suggestions?

Thanks,
Chris

[Graham Mayor]

Peter,

You may find the macro at http://www.gmayor.com/export_field.htm useful as
it exports the fields intact to a text string which can be pasted into a NG
message, thus avoiding such typos.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Peter Jamieson wrote:
a. I've missed the closing quotes and field brace:

b. It may need quotes around the format, i.e.

{ IF { MERGEFIELD myamount } 0.995 "{ MERGEFIELD myamount
\#"£,0.00" }" "{ ={ MERGEFIELD myamount } * 100 \#"00p" }" }

If you still have trouble I suppose I would try the following next

{ IF { MERGEFIELD myamount } 0.995 "{ MERGEFIELD myamount
\#"£,0.00" }" "{ ={ MERGEFIELD myamount } * 100 \#"00" }p" }

Peter Jamieson


"Chris Stammers" wrote in
message ...
Hello again,

Thanks for this query. I have placed it into 2 documents. It works
in one place in one document. However it seems that when the query
is converting to
pence, only part of the paragraph it is part of will generate. The
pound formatting works fine.

However, the other document I have placed it in doesn't work at all
if that
query is placed in it; all I get is 'Field Calculation Error in
Record 1' etc.

Any ideas?

Thanks,
Chris


"Peter Jamieson" wrote:

Try

{ IF { MERGEFIELD myamount } 0.995 "{ MERGEFIELD myamount
\#£,0.00 }" "{ ={ MERGEFIELD myamount } * 100 \#00p }

Peter Jamieson
"Chris Stammers" wrote in
message
...
I need to format a currency field to be £0.00 if greater than £1
and 00p if
less than £1 in the data source. The data source holds the data as
1.00 or
.50. I have created this query: {IF { MERGEFIELD } 1
"£{MERGEFIELD\#,0.00 }
"{ MERGEFIELD\#.00 }p" }

The query does work but where there is just .50, it shows in the
merge doc
with a leading decimal point. My question is this - is there a
formatting
switch to get rid of the decimal point in the case where it is just
pence?
I
have tried taking the decimal point away and the query stops
working. I tried
susbtituting the hash sign for a '@' instead and that didn't work
either.
Any
suggestions?

Thanks,
Chris

[Peter Jamieson]

Thanks for the reminder Graham.

Peter Jamieson

"Graham Mayor" wrote in message
...
Peter,

You may find the macro at http://www.gmayor.com/export_field.htm useful as
it exports the fields intact to a text string which can be pasted into a
NG message, thus avoiding such typos.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Peter Jamieson wrote:
a. I've missed the closing quotes and field brace:

b. It may need quotes around the format, i.e.

{ IF { MERGEFIELD myamount } 0.995 "{ MERGEFIELD myamount
\#"£,0.00" }" "{ ={ MERGEFIELD myamount } * 100 \#"00p" }" }

If you still have trouble I suppose I would try the following next

{ IF { MERGEFIELD myamount } 0.995 "{ MERGEFIELD myamount
\#"£,0.00" }" "{ ={ MERGEFIELD myamount } * 100 \#"00" }p" }

Peter Jamieson


"Chris Stammers" wrote in
message ...
Hello again,

Thanks for this query. I have placed it into 2 documents. It works
in one place in one document. However it seems that when the query
is converting to
pence, only part of the paragraph it is part of will generate. The
pound formatting works fine.

However, the other document I have placed it in doesn't work at all
if that
query is placed in it; all I get is 'Field Calculation Error in
Record 1' etc.

Any ideas?

Thanks,
Chris


"Peter Jamieson" wrote:

Try

{ IF { MERGEFIELD myamount } 0.995 "{ MERGEFIELD myamount
\#£,0.00 }" "{ ={ MERGEFIELD myamount } * 100 \#00p }

Peter Jamieson
"Chris Stammers" wrote in
message
...
I need to format a currency field to be £0.00 if greater than £1
and 00p if
less than £1 in the data source. The data source holds the data as
1.00 or
.50. I have created this query: {IF { MERGEFIELD } 1
"£{MERGEFIELD\#,0.00 }
"{ MERGEFIELD\#.00 }p" }

The query does work but where there is just .50, it shows in the
merge doc
with a leading decimal point. My question is this - is there a
formatting
switch to get rid of the decimal point in the case where it is just
pence?
I
have tried taking the decimal point away and the query stops
working. I tried
susbtituting the hash sign for a '@' instead and that didn't work
either.
Any
suggestions?

Thanks,
Chris