i'm using Access 2003 and have a field in a table called NUM that can be look like any of the examples below:
I am building a report and there are couple of results I want to display NUM in two columns, one for numbers and the other for suffixes. So, with the above examples, my report would look like:
1108 | |
1010 |A/B |
1020/1030/1040 | |
I was going to use regexp, but I am not sure how to set the pattern, because of the "/" that can appear unlimited times.