i had try your solution mr.ramkumar...but i get message "syntax error in from clause"

this is my code:

Dim rsx As Recordset

Dim reg_year As String

Set rsx = dbStudent.OpenRecordset("select distinct * from (select...

i'm sorry mr jeff...is it the syntax of msql?but i wanna make it in access from vb 6.0 code?can it be?please help me...