il ya des probleme dans la calcule de moyenns
<html>
<%
set bd=server.createobject("adodb.connection")
bd.open"Driver={Microsoft access driver (*.mdb)};dbq="& server.mappath ("base.mdb")
set st=bd.execute("select libelle,coef,notematiere from matiere,base where base.nmatiere=matiere.nmatiere and nute='"&session("a")&"'") %>
<body background ="image.jpg">
<center><u><font size=6 color=red>Les notes de :</font><font size=6 color=blue> <%=session ("a")%></u></font></center><br><br>
<center><table border=3 width="500" bgcolor=gold>
<tr><th><font size=5 color=red>Matiere</font><th><font size=5 color=red>Coef</font><th><font size=5 color=red>Note</font><th><font size=5 color=red>Note * Coef</font>
<% while not (st.eof)%>
<tr><td><font size=5 color=blue><%=st("libelle")%></font><td><font size=5 color=black><%=st("coef")%></font><td><font size=5 color=red><%=st("notematiere")%></font><td><font size=5 color=black><%=st("coef")*st("notematiere")%></font>
<% st.movenext
wend
%>
<% set base=server.createobject("adodb.connection")
base.open"Driver={Microsoft access driver (*.mdb)};dbq="& server.mappath ("base.mdb")
set rs=base.execute("select sum (coef) as sc,sum (coef*notematiere)as snc from matiere,base where base.nmatiere=matiere.nmatiere group by nute") %>
<tr><td><font size=5 color=red>Total : </font><td><font size=5 color=green><% =rs("sc")%></font><td><td><font size=5 color=green><% =rs("snc")%></font>
<tr><td><font size=5 color=red>Moyenne : </font><td colspan=4 align=center><font size=5 color=blue><% =rs("snc")/rs("sc")%></font>
</table>