AnsweredAssumed Answered

Joining fields for human readable purposes...having trouble with a little formulating...

Question asked by ijontichy on Nov 26, 2012
Latest reply on Nov 26, 2012 by philmodjunk

Title

Joining fields for human readable purposes...having trouble with a little formulating...

Post

     Filemaker Pro Advanced 11.03.   Mac.

      

     I'm trying to create a human readable change list for a project that concatenates several fields into one report per record.  All of the information is from the same table.   There are as many as 8 unique items I need to report on.  I'd like it so that the calculation adds  two paragraph returns and the text "AND:  " but only if there is additional information from later items.

      

     Item 1

     AND:   Item 2

     AND:  Item 3

     etc.

      

     But If there is no item 2 I don't want

     Item 1

     AND:  

     AND:  Item 3

      

     Which is what I've currently managed to achieve.

      

     Thank you in advance for any help or suggestions.

Outcomes