I am trying to group records in a report that need to be grouped on a record ID that contains “-” in the ID… to elaborate a record ID contains some numbers and letters followed by a “-” and then more numbers and letters… I need to group on everything after the “-” but the record ID contains different string lengths before and after the “-“… I am at a loss on how to do this since I don’t know how to look for the “-” in the string and then group on the part of the string that follows… can anyone point me in the right direction… I have tried various combinations of the mid$, left$ and Right$ functions but cannot pin this down so that it works
thank you
