[LabrGuy Bob R]

I did some more checking and found the original Excel database from where
these are imported to have the $0.00, but only in some of the cells. So my
question changes to one of would this statement work for all the cells??? IF
{ Mergefield "YECMP" } = "$0.00" "" "{ Mergefield "YECMP" } I think this
will check and see if the value is $0.00 and return a blank and if not blank
return the value.? Am I close.
Thanks
BOB


"LabrGuy Bob R" wrote in message
...
Thanks for the response. I've searched all over and am a little familiar
with switches etc. I can't find an answer for this problem. As you can see
each table cell that contains merge data is underlined.All are formatted
with the switch that you provided, and that is like the {CSERACMP \#
$,0.00} below. The underlined areas are each a cell, couldn't get the
gridlines to print out, and where you see no $0.00 is formatted exactly
the same as the ones with $0.00. My delima is I can't get all of them the
same..... either without the $0.00 at all or show all with the $0.00.

My apologies for not being clear before but I'm kinda at my wits end with
this one. Thanks in advance.
Bob

Youth Employment Violation(s):



$0.00

$0.00

Recordkeeping Violation(s):



$0.00

$0.00

CSERA Violation(s):

{CSERACMP \# $,0.00}

$0.00

$0.00

Total:

$0.00






"macropod" wrote in message
...
Hi Bob,

It's not exactly clear what you're trying to do.

So you've apparently got some headers:
'Assessed' 'Reduction' 'Total Due'
and a bunch of mailmerge fields:
«YECMP» «YECMPREDUCTAMT» «YECCMPTOTDUE» «RKCMP» «RKCMPREDUCAMOUNT»
«RKCMPTOTDUE» «CSERACMP» «CSERAREDUCTAMT» «CSERACMPTOTDUE»
«TOTALCMPSASSESD» «TOTALCMPRED» «TOTALCMPDUE»

I don't see any formulae that might relate these to each other in any
way.

You also say "I need to show $0.00 all the time in the table boxes as
indicated". I don't see a table - all I see is a single column with the
above mergefields/strings followed by a repeat of what appears to be the
header strings followed by some $0.00s. By "I need to show $0.00", do you
mean you need the mailmerge results to show as currency? If so, select
the mailmerge fields that need to be displayed this way, press Shift-F9
to expose the field code (eg «YECMP» becomed {YECMP}), then add a
currency picture switch to the field, thus {YECMP \# $,0.00}.

See Word's help file for more information on field formatting. This
newsgroup is also replete with questions and answers about mergefield
formatting.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"LabrGuy Bob R" wrote in message
...
Hello, I have WORD 2003 and Win XPPro. I have a table, as show below
that shows Assessed values of a fine -- Reduction amount of the fine --
and the total due of the fine.
It is a mail merge document that draws information from an Excel
spreadsheet/database. All of the cells appear to be formatted the same
way and the formulas are all calculated the same.

I need to show $0.00 all the time in the table boxes as indicated in the
tables below. I actually need to display and print $0.00 in the Assessed
column for three, the Reductions column 4th total cell and in the Total
Due the Total due.

Or if I can't get that settled then I would like to have all blanks in
each, and when merged show the actual dollar value with the blanks as
blank. Whichever..

I've tried everything that I can figure out with no luck.

Any help would be greatly appreciated
Thanks
BOB


Assessed

Reduction

Total Due

«YECMP»

«YECMPREDUCTAMT»

«YECCMPTOTDUE»

«RKCMP»

«RKCMPREDUCAMOUNT»

«RKCMPTOTDUE»

«CSERACMP»

«CSERAREDUCTAMT»

«CSERACMPTOTDUE»

«TOTALCMPSASSESD»

«TOTALCMPRED»

«TOTALCMPDUE»




Assessed

Reduction

Total Due



$0.00

$0.00



$0.00

$0.00



$0.00

$0.00

$0.00