Try using the following query:

SELECT DISTINCT (mid(no_reg,3,2))

FROM students

It avoids using subqueries, and should work in MS Access.