I am pulling a field that in our system is a multiple select question therefore when I add the field into the report it brings back data that looks like the following:
case recordreview&client&staff&juvenile&caregiver&youth
I would like to separate each selection but if thats not possible then i would like to replace the & with commas
The reason i would like to separate the fields is because i need to pull the records that have Juvenile selected as one of the answers
please let me know if i need to do more clarification on what i need
thank you
IP Logged
