AnsweredAssumed Answered

How to summarize value list?

Question asked by bookalaka_1 on Nov 20, 2010
Latest reply on Nov 22, 2010 by philmodjunk


How to summarize value list?


I would like to advice on this solution. I am creating a form for sales calls with a field with 10 multiple values with check boxes.

Doesn't need, Too expensive,  Follow Up, etc ... What I would like to happen is as every box is checked the result goes into a text  field that can then be  exported to excel.

I know I can create single fields and string them together although I haven't been able to figure out how not to show the comma when a result isnt selected. example;  Loved & "," & dislikes & "," & follow up.

Preferably would like to have one field with multiple check boxes and a summary of the results in a text field.

I couldn't find any post for this but somehow I feel it must be done all the time.

Thanks for guidance.