Hi,

We use Access 97 and I am trying to do something in a query but need some help.
Hopefully someone here will be able to do this for me.

I have a query that is picking up a field that I need to sort by.
The field is called IntRef and the data is in the format of xxx/yyy.
Both xxx and yyy can be 1, 2 or 3 digits.
This is a text field, (I can't change that as it is coming from a linked table)....