View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
lemon scented lemon scented is offline
external usenet poster
 
Posts: 1
Default How list people for some modules or for all modules

A couple of related questions.

I would like to list people who are registered for each module of training.
People can register for 1, 2, 3, 4, or all 5 modules. Thus the same person
may be listed several times. If a person is registered for a module, the
module code is "1." If they are not registered, the module code is "0."

1. I tried to use the "Next record if" rule. However, the rule doesn't
seem to work very intuitively. When I select rule -- Next record if -- and
fill in "module1" equal to "1," the code «Next Record If...» is inserted.
However something like Module1 = 1 does not appear with it . It is not clear
what the "Next record if..." code does without this information. So, how
does this rule work? I can find very little useful information to help me.

2. If I could get the rule to work, how could I have something like the
following (in my simple terms). That is, what is the code to make the merge
process look through the entire list to see who is in module 1 and list them,
then go through the list to see who is in module 2 and list them, etc.

Module 1
«firstname» «lastname» [for all cases in which module1 = 1]

Module 2
«firstname» «lastname» [for all cases in which module2 = 1]

Module 3
«firstname» «lastname» [for all cases in which module3 = 1]
etc.

Also, any recommendations for references that spell out clearly how the
codes work and how to use them would be greatly appreciated. What I have
seen so far is not written in clear English so that regular people can
understand.

Thank you for any help.