Hi Guys I got an iIdea from previous post to show my problem.

below is the result of my query.

 AcctNO | COUNT |
----------------------------------------
11111 | 10 |
11111 | 20 |
11111 | 30 |
11111 | 40 |
22222 | 20 |
22222 | 30 |
22222 | 40 |
22222 | 50 |


heres the result what I want.

 AcctNO | COUNT |
----------------------------------------
11111 | 10 |
11111 | 20 |
11111 | 30 |
11111 | 40 |
Total | 100 |
22222 | 20 |
22222 | 30 |
22222 | 40 |
22222 | 50 |
Total | 140 |

I know it can't be done it SQL command.
how can I Display it in HTML

Thanks

you can do it in SQL.Use Rollup & u will get the desired result in SQL only.
Use do while to print in ASP

Ashwin S.Kenkare
Programmer
CMI

Ashwin,

Great SQL Rollup up works :). I really appreciate your help.

Thanks,
Elmer