hey everyone,
I had this working a few weeks ago but ive upgraded my database from Access
2000 to Access 2003 and now i have lots of formatting problems with
calculated values in an access query that i want to format as currency.

Im using the following and works as long as its not part of an IF statement,

{MERGEFIELD "M_42Pay1" \#"£0000.00}

works great and brings up the correct value as a currency just fine!
but i really need this in a statement like this:

{If {MERGEFIELD "GarantorsSname} "" "Payment 1: {MERGEFIELD "M_42Pay1"
\#"£0000.00} Due on Mergefield "M_06pay1dateHome"}

And this doesnt format that same value correctly, it shows it as a plain
number!!
Also how do i get subsequent payments to line up underneath this one?

{If {MERGEFIELD "M_42Pay2"} ="£0.00" {"Payment 2: {MERGEFIELD "M_42Pay2"
\#"£0000.00} Due on Mergefield "M_06pay2dateHome"}

should bring up the second payment due, however instead of a neat:

Payment 1: £1000 due on 01/01/2006
Payment 2: £1000 due on 01/03/2006

i get: Payment 1: £1000 due on 01/01/2006Payment 2: £1000 due on 01/03/2006

All on one line with no spaces or formatting, ive tried putting in
breaklines and paragraph marks in the IF quotations and between the blocks of
code but its not working!!!

can you help me on either (& hopefully both) of these problems?

The field construction should be

{ If { MERGEFIELD GarantorsSname} "" "Payment 1: { MERGEFIELD M_42Pay1
\# "£0000.00"} Due on { Mergefield M_06pay1dateHome}" }

Each pair of field delimiters must be inserted using Ctrl+F9
--
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

"DowningDevelopments" wrote
in message ...
hey everyone,
I had this working a few weeks ago but ive upgraded my database from
Access
2000 to Access 2003 and now i have lots of formatting problems with
calculated values in an access query that i want to format as currency.

Im using the following and works as long as its not part of an IF
statement,




works great and brings up the correct value as a currency just fine!
but i really need this in a statement like this:

{If {MERGEFIELD "GarantorsSname} "" "Payment 1: {MERGEFIELD "M_42Pay1"
\#"£0000.00} Due on Mergefield "M_06pay1dateHome"}

And this doesnt format that same value correctly, it shows it as a plain
number!!
Also how do i get subsequent payments to line up underneath this one?

{If {MERGEFIELD "M_42Pay2"} ="£0.00" {"Payment 2: {MERGEFIELD "M_42Pay2"
\#"£0000.00} Due on Mergefield "M_06pay2dateHome"}

should bring up the second payment due, however instead of a neat:

Payment 1: £1000 due on 01/01/2006
Payment 2: £1000 due on 01/03/2006

i get: Payment 1: £1000 due on 01/01/2006Payment 2: £1000 due on
01/03/2006

All on one line with no spaces or formatting, ive tried putting in
breaklines and paragraph marks in the IF quotations and between the blocks
of
code but its not working!!!

can you help me on either (& hopefully both) of these problems?

Or even

{ If { MERGEFIELD GarantorsSname } "" "Payment 1: { MERGEFIELD M_42Pay1
\# "£,0.00" } Due on { Mergefield M_06pay1dateHome \@ "dd/MM/yyyy" }{ If
{ MERGEFIELD M_42Pay2 \# "0" } = 0 "¶Payment 2: { MERGEFIELD M_42Pay2 \#
"£,0.00" } Due on { Mergefield M_06pay2dateHome \@ "dd/MM/yyyy" }" }" }

Assuming that all this is only entered if the GarantorsSname field has
content then will also show the second field when the content is 0. Press
the enter key where the ¶ symbol is. Watch out for spacing and quotes. The
currency switches will include commas as thousands separators and date
switches are added to force your preferred date format.

If the second line is independant of the Garantorsname field content then
that part of the statement needs to be moved outside the first conditional
field thus:

{ If { MERGEFIELD GarantorsSname } "" "Payment 1: { MERGEFIELD M_42Pay1
\# "£,0.00" } Due on { Mergefield M_06pay1dateHome \@ "dd/MM/yyyy" }" }{
If { MERGEFIELD M_42Pay2 \# "0" } = 0 "¶Payment 2: { MERGEFIELD M_42Pay2 \#
"£,0.00" } Due on { Mergefield M_06pay2dateHome \@ "dd/MM/yyyy" }" }

See also http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

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



Doug Robbins - Word MVP wrote:
The field construction should be

{ If { MERGEFIELD GarantorsSname} "" "Payment 1: { MERGEFIELD
M_42Pay1 \# "£0000.00"} Due on { Mergefield M_06pay1dateHome}" }

Each pair of field delimiters must be inserted using Ctrl+F9

"DowningDevelopments"
wrote in message
...
hey everyone,
I had this working a few weeks ago but ive upgraded my database from
Access
2000 to Access 2003 and now i have lots of formatting problems with
calculated values in an access query that i want to format as
currency. Im using the following and works as long as its not part of an
IF
statement,




works great and brings up the correct value as a currency just fine!
but i really need this in a statement like this:

{If {MERGEFIELD "GarantorsSname} "" "Payment 1: {MERGEFIELD
"M_42Pay1" \#"£0000.00} Due on Mergefield "M_06pay1dateHome"}

And this doesnt format that same value correctly, it shows it as a
plain number!!
Also how do i get subsequent payments to line up underneath this one?

{If {MERGEFIELD "M_42Pay2"} ="£0.00" {"Payment 2: {MERGEFIELD
"M_42Pay2" \#"£0000.00} Due on Mergefield "M_06pay2dateHome"}

should bring up the second payment due, however instead of a neat:

Payment 1: £1000 due on 01/01/2006
Payment 2: £1000 due on 01/03/2006

i get: Payment 1: £1000 due on 01/01/2006Payment 2: £1000 due on
01/03/2006

All on one line with no spaces or formatting, ive tried putting in
breaklines and paragraph marks in the IF quotations and between the
blocks of
code but its not working!!!

can you help me on either (& hopefully both) of these problems?