If I select multiple values using a drop down list, the resulting values show in the database with a comma separating each value. Is there a way to seperate those variable when i pull a report so each instance will be counted as 1 item. for example, I have a database ive been testing to collect a callers basic information and needs. I have a report that sorts all the callers by needs. is there a way to get the values seperated by a comma to appear under their specific Need catagory in the report and not all together classified as one need? I hope that makes sense.
see image below
