You have to check the contents of each field separately and then combine the results.
Substitute ( List ( If (F1 = "X" ; "one" ) ; If ( F2 = "X" ; "Two" ) ; If ( F3 = "X" ; "Three" ) ; If ( F4 = "X" ; "Four" ) ) ; ¶ ; ", " )
But if you replaced your 4 separate fields with one text field formatted as a check box set with the values One ; Two ; Three ; ..., All you would need would be this calculation:
Substitute ( CheckBoxField ; ¶ ; ", " )
Yes, I agree it would be much easier the second way and how I would have liked to set it up but I'm working off old info that was pulled in from what was originally an excel document completed with all seperate columns.....thought it would be easier to do this in a report i'm generating rather than re-doing the way it was originally set up.
Thanks again!!! :)