sub-totals not using database wizard - using SQL DB

[Cheryl]

How can I make a page that displays sub-totals? I can make it total for the
entire report.. but not by day? I can do it using the wizard in Access...
based on
http://home.att.net/~codeLibrary/FrontPage/subquery.htm I can do the
sub-totals in that manner... However, this is an SQL database not an access
one.... and I have to code without using the wizard.. Could some one explain
the logic of:
<%
If fp_rs("Count") = FP_Save + 1 Then
FP_Save = 0
%>
<tr>...</tr>
<%
Else
FP_Save = FP_Save + 1
End If
%>
So that I can understand how to code it for my own purposes...

Thanks,