Viewing post 1 (of 1 total)
Try using the following query:
SELECT DISTINCT (mid(no_reg,3,2))
FROM students
It avoids using subqueries, and should work in MS Access.
May 13, 2008 at 3:15 pm
#814829