Count fra tabellen

Jeg skal lave en liste ud fra en tabel hvor den skal tælle ud fra en anden tabel
Hvad gør jeg galt
------------------------------------------------------
<%
Set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & Server.MapPath (\"db/db.mdb\")
set rs = Conn.execute(\"select * from claner order by navn desc\")

if rs.EOF then
Response.write \"Databasen er tom.\"
else
Do Until rs.EOF
set temp = Conn.Execute(\"select count(*)  as antal from brugere where navn= \' & rs(\"navn\")\')
%>


  <tr>
    <td width=\"20%\" bgcolor=\"#C0C0C0\"><font face=\"Verdana\" size=\"2\" color=\"#000000\">  <%= rs(\"tag\") %></td>
    <td width=\"58%\" align=\"center\" bgcolor=\"#C0C0C0\"><font face=\"Verdana\" size=\"2\" color=\"#000000\"><a href=\"default.asp?mode=clan&navn=<%= rs(\"navn\") %>\"><%= rs(\"navn\") %></td>
    <td width=\"11%\" align=\"center\" bgcolor=\"#C0C0C0\"><font face=\"Verdana\" size=\"2\" color=\"#000000\"><%= rs(\"rekrut\") %></td>
    <td width=\"11%\" align=\"center\" bgcolor=\"#C0C0C0\"><font face=\"Verdana\" size=\"2\" color=\"#000000\"><%=temp(\"antal\")%></td>
  </tr>

<%RS.MoveNext
Loop
end if

Conn.Close
Set Conn = Nothing%>