I have a database that has multiple references created by a radio button. This delivers a field with a string of all of the selections made. I would like to strip out the individual entries and then group on each.
My first question is;
I can only seem to extract one reference per formula, using the "In String" condition. This means I have to have a formula for each reference. Is there another condition that I should be using?
Second;
If I group on a reference, the record is only displayed once in the report, where it is tagged by multiple reference in the radio buttons. I need it to be shown in the detail against all corresponding group headers.
I would really appreciate some advice.
Many thanks
IP Logged
