1 Reply Latest reply on Nov 26, 2012 3:36 PM by philmodjunk

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

    ijontichy

      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.