-------------------------------
Réponse au message :
tu peu etuliser la fontion
select count(*) ou sum(*) voila un exemple :
<%
Set objConn= Server.Createobject("ADODB.Connection")
objConn.open "dsn=STAGEDBA;uid=system;pwd=manager;"
SQLQuery="SELECT a.cod_serv,b.lib_serv,sum(*)total from admission a,service b where a.cod_serv=b.cod_serv and date_adm between '"&dd&"' and '"&df&"' group by a.cod_serv,b.lib_serv"
Set RS= objConn.execute(SQLQuery)
%>
<center>
<table border="2" width="75%" height="28">
<tr>
<td width="15%" align="center" style="background-color: #0000FF" height="1"> Code </td>
<td width ="40%" align= "center" style="background-color: #0000FF" height="1"> Service </td>
<td width ="15%" align= "center" style="background-color: #0000FF" height="1">
total </td>
</td>
</tr>
<% do while not RS.eof %>