Repeating data in Merge or conditional use of fields

*** Newbie Alert *** (Felt I should warn you)

I have an application (off the shelf, not my own) that writes reports
to MS Word by outputting information into a Mail Merge Source and
having a DOT template pick up the fields for the report.

I have a test file that has 5 items and 4 fields within each item can
contain the name of an 'area' that I want to report on. eg Item 1 has
to be in 2 areas so 2 of the 4 fields contain the names of the area
and 2 are blank.

Ultimately I wanted to structure the report for each of the 'areas' so
that all the items that are linked to that area (viz the area appears
in 1 of the 4 fields) are listed together. If an item had more than
one area, the information would be repeated in the report.

I've got down to running a separate merge for each area (to be
combined in a manual process) and only want the information to be
displayed if the area name appears in 1 of the 4 fields.

I'm using the {IF {MERGEFIELD <Name>} = "Area1" "This is the
information"} but it's displaying information from all the items. I
tried reverse logic {IF {MERGEFIELD <Name>} <> "Area1" ""} but since
there are 4 fields to check its not working as I'd expect.

I'd like to be able to set up a variable so I can test each of the 4
fields and change the variable to True when I want the information
displayed.

Any ideas or hints would be great.

Thanks

(Version MS Word 2002 SP3)

.

Relevant Pages

  • hon puzzled yacht for example Satam AL-Sheikhs look
    ... Try not to share freely while you're displaying in addition a ... Almost no physical younger surveyors now carve as the ... Dianna piles, then Zephram normally enables a abysmal agreement ... report over or Ralf will file the consents. ...
    (sci.crypt)
  • Re: Repeating data in Merge or conditional use of fields
    ... See the "Group Multiple items for a single condition" item on fellow MVP ... having a DOT template pick up the fields for the report. ... I have a test file that has 5 items and 4 fields within each item can ... information"} but it's displaying information from all the items. ...
    (microsoft.public.word.mailmerge.fields)
  • Print button displays warning dialog when using SSL
    ... When displaying a report using the CyrstalReportViewer component in ... Print button to get the PDF version of the report in that little popup ... I cannot seem to find a fix for this -- it should be a simple ... KNOW it will screw something up, and it's such a pain to get CR10 ...
    (microsoft.public.vb.crystal)
  • Re: #Errors-on report
    ... >> I have a report that asks the user for a processing date. ... >> displaying a prompt letting the user know that the selection is invalid so ... Examine the SQL of the Combo Box RowSource property. ... Set the Combo box bound column to 1. ...
    (microsoft.public.access.reports)
  • Re: Why does my report display a value different than that of the
    ... To which field is the textbox on your report bound, ... Change the query to use the Name/Description field ... I had a simular issue yesterday when displaying a calculated value. ...
    (microsoft.public.access.reports)