View Single Post
  #1   Report Post  
Walter
 
Posts: n/a
Default complex conditional merge

If a field is in two different IF...THEN...ELSE merge statements, is there a
way to make the second statement skip that field if the first statement has
inserted it into the document?

Here's the application:
This merge uses fields for a Service, Level (of service), and Status. There
are 5 of each available to each record. What I need to do is merge the
Services and the related Level to a 5-slot list on a report. (That part's
easy.) If the Service has been completed, it should not show up. (Also easy.)
But say Service1 is complete, but Service2 is not; now Service2 needs to move
to the top of the list on the report. (A little more difficult, but I think
I've got it working.) What can I include in the IF...THEN...ELSE statement so
that Service2 will no longer show up in slot 2 of the report, once it's been
put into slot 1?

Any suggestions, or directions to other resources, would be appreciated very
much! Thanks!