However the number is not an autonumber part, it is entered by users. Sometimes these users put too many letters in, like this "AAa10199" so my original sort for the table fails.
This was
Expand|Select|Wrap|Line Numbers
- cint(mid([ar_id],3,8))
But with extra letters added an error is returned and the sort fails, so I thought this may work.
Expand|Select|Wrap|Line Numbers
- IIf((IsNumeric(CInt(Mid([ar_id],3,8)))),CInt(Mid([ar_id],3,8)),0)