Count problem

Jeg tror aldrig jeg helt har fattet det her count skidt:

SQL = "SELECT video.Titel, count(oenskeliste.filmid) AS antal FROM oenskeliste, video WHERE oenskeliste.filmid=video.FilmID group by oenskeliste.filmid ORDER BY antal DESC"
Set RS = Server.CreateObject("ADODB.Recordset")
RS.CursorLocation = 3
RS.CursorType = 3
RS.ActiveConnection = Conn
RS.Open SQL, Conn, 1, 3
If NOT (RS.BOF AND RS.EOF) Then
do until RS.eof
titel=RS("Titel")
antal=RS("antal")
%>
<tr><td><%=antal%></td><td><%=titel%></td></tr>
<%RS.movenext
loop
else%>
<tr><td colspan="2">There are current no members</td></tr>
<%
End If
RS.close
Set RS = Nothing
%>



Fejl:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified expression 'Titel' as part of an aggregate function.