Is it possible to do query of the first SQL query I do?

This gave me no duplicated matches when I tried it in Access query 

designer.



I did a query on my first SQL listed below then did:

SELECT DISTINCT [FilmID], [Tittel], [Kategori], [Pris]

FROM [mySQLquery];



But using a new execute command didn't seem to work. 





---

My code:



SQL="SELECT [khitfilm].[FilmID], [khitfilm].[Tittel], [Khitkategori].

[Kategori], [khitpris].[Pris], [khitskue].[Skuespiller]" & _

    " FROM ((khitfilm INNER JOIN khitpris ON [khitfilm].[FilmID] 

[khitpris].[FilmID]) INNER JOIN (khitskue INNER JOIN khitfs ON [khitskue].

[SkueID] =[khitfs].[SkueID]) ON [khitfilm].[FilmID] =[khitfs].[FilmID]) 

INNER JOIN Khitkategori ON [khitfilm].[FilmID] =[Khitkategori].[FilmID]" & 

_

	" WHERE " & Request("choice") & " LIKE '%" & Request("strSearch") 

& "%' ORDER BY " & Request("choice")

	

Set RS = MyConn.Execute(SQL)



nSQL =  "SELECT DISTINCT [Tittel], [FilmID], [Kategori], [Pris] FROM [SQL]"

  

Set RS = MyConn.Execute(nSQL)