How not to display first value???

[ombina]

Hello,

I am trying to find out how not to display the first value when looping -

Results should look like this:

Product 1 stock
item 1 100
item 2 300
Total 400

Product 2 stock
item a 400
item b 800
Total 1200

NOT like this -

Total 100
Product 1 stock
item 1 100
item 2 300
Total 400

Product 2 stock
item a 400
item b 800
Total 1200
Thanks,

Ricky Ombina
ombina@yahoo.com

http://www.ombina.com

 

[onpnt]

code?? please?? I dare to learn more

http://www.onpntwebdesigns.com

admin@onpntwebdesigns.com

 

[ombina]

rs.moveFirst

Do While Not rs.eof

If left(rs(&quot;DESCRIPTION&quot,3) <> &quot;ALL&quot; then

origCode = left(rs(&quot;DESCRIPTION&quot,1)

If origCode = &quot;A&quot; then
codeDesc = &quot;Account Type&quot;
ElseIf origCode = &quot;E&quot; then
codeDesc = &quot;EEE&quot;
ElseIf origCode = &quot;C&quot; then
codeDesc = &quot;SSS&quot;
ElseIf origCode = &quot;K&quot; then
codeDesc = &quot;CCC&quot;
ElseIf origCode = &quot;I&quot; then
codeDesc = &quot;CCC&quot;
ElseIf origCode = &quot;S&quot; then
codeDesc = &quot;AAA&quot;
End If

'*************************************************************************************
If origCode <> lastCode then

response.write&quot; <tr>&quot;
response.write&quot; <td WIDTH=&quot;&quot;65%&quot;&quot; HEIGHT=&quot;&quot;10&quot;&quot; bgcolor=&quot;&quot;#EFEFEF&quot;&quot;>&quot;
response.write&quot; <p ALIGN=&quot;&quot;LEFT&quot;&quot;><b><font face=&quot;&quot;Arial&quot;&quot; size=&quot;&quot;1&quot;&quot;>&quot;
response.write&quot;TOTAL&quot;
response.write&quot;</font></b></td>&quot;

response.write&quot; <td WIDTH=&quot;&quot;20%&quot;&quot; HEIGHT=&quot;&quot;10&quot;&quot; bgcolor=&quot;&quot;#EFEFEF&quot;&quot; align=&quot;&quot;center&quot;&quot;><font FACE=&quot;&quot;Arial&quot;&quot; SIZE=&quot;&quot;1&quot;&quot;>&quot;
response.write&quot; <p ALIGN=&quot;&quot;RIGHT&quot;&quot;>&quot;
response.write formatNumber(totRec,0)
response.write&quot; </font></td>&quot;
response.write&quot; </tr>&quot;

response.write&quot; <tr>&quot;
response.write&quot; <td WIDTH=&quot;&quot;65%&quot;&quot; HEIGHT=&quot;&quot;10&quot;&quot; bgcolor=&quot;&quot;#FFFFFF&quot;&quot;>&quot;
response.write&quot; <p ALIGN=&quot;&quot;CENTER&quot;&quot;><b><font face=&quot;&quot;Arial&quot;&quot; size=&quot;&quot;1&quot;&quot;>&quot;
response.write ucase(codeDesc)
response.write&quot;</font></b></td>&quot;
response.write&quot; <td WIDTH=&quot;&quot;20%&quot;&quot; HEIGHT=&quot;&quot;10&quot;&quot; align=&quot;&quot;center&quot;&quot;><font FACE=&quot;&quot;Arial&quot;&quot; SIZE=&quot;&quot;1&quot;&quot;>&quot;
response.write&quot; <p ALIGN=&quot;&quot;RIGHT&quot;&quot;>&quot;
response.write&quot; </font></td>&quot;
response.write&quot; </tr>&quot;

totRec = 0

End If
lastCode = origCode
'*************************************************************************************

If origCode <> &quot;&quot; then

response.write&quot; <tr>&quot;
response.write&quot; <td WIDTH=&quot;&quot;65%&quot;&quot; HEIGHT=&quot;&quot;10&quot;&quot; bgcolor=&quot;&quot;#F1FFF0&quot;&quot;>&quot;
response.write&quot; <p ALIGN=&quot;&quot;LEFT&quot;&quot;><b><font face=&quot;&quot;Arial&quot;&quot; size=&quot;&quot;1&quot;&quot;>&quot;
response.write rs(&quot;DESCRIPTION&quot
response.write&quot;</font></b></td>&quot;

response.write&quot; <td WIDTH=&quot;&quot;20%&quot;&quot; HEIGHT=&quot;&quot;10&quot;&quot; bgcolor=&quot;&quot;#EFEFEF&quot;&quot; align=&quot;&quot;center&quot;&quot;><font FACE=&quot;&quot;Arial&quot;&quot; SIZE=&quot;&quot;1&quot;&quot;>&quot;
response.write&quot; <p ALIGN=&quot;&quot;RIGHT&quot;&quot;>&quot;
response.write formatNumber(rs(&quot;MONTH&quot,0)
response.write&quot; </font></td>&quot;
'response.write&quot; </tr>&quot;


End If
'*************************************************************************************

lastTotRec = totRec
End If

v = rs(&quot;MONTH&quot
totRec = totRec + v

rs.MoveNext
cnt = cnt + 1
Loop
'*************************************************************************************

If origCode <> &quot;&quot; then

response.write&quot; <tr>&quot;
response.write&quot; <td WIDTH=&quot;&quot;65%&quot;&quot; HEIGHT=&quot;&quot;10&quot;&quot; bgcolor=&quot;&quot;#EFEFEF&quot;&quot;>&quot;
response.write&quot; <p ALIGN=&quot;&quot;LEFT&quot;&quot;><b><font face=&quot;&quot;Arial&quot;&quot; size=&quot;&quot;1&quot;&quot;>&quot;
response.write&quot;TOTAL - EOF&quot;
response.write&quot;</font></b></td>&quot;

response.write&quot; <td WIDTH=&quot;&quot;20%&quot;&quot; HEIGHT=&quot;&quot;10&quot;&quot; bgcolor=&quot;&quot;#EFEFEF&quot;&quot; align=&quot;&quot;center&quot;&quot;><font FACE=&quot;&quot;Arial&quot;&quot; SIZE=&quot;&quot;1&quot;&quot;>&quot;
response.write&quot; <p ALIGN=&quot;&quot;RIGHT&quot;&quot;>&quot;
response.write formatNumber(totRec,0)
response.write&quot; </font></td>&quot;
response.write&quot; </tr>&quot;

End If
'*************************************************************************************

RS.Close
Conn.Close
Set RS=Nothing
Set Conn=Nothing
%> Thanks,

Ricky Ombina
ombina@yahoo.com

http://www.ombina.com