|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
October 8th, 2003, 12:29 PM
|
|||
|
|||
need help on subtotal line
I am working on a summary report with ASP to get the sum number of each field from Access Database. Right now I need to add an subtotal line to the report like this:
Region Month Data A 2 1 A 3 2 A 4 3 A Subtotal 6 B 2 2 B 3 2 B Subtotal 4 Total 10 I would really appreciate if anyone could like to share their sample subtotal method or code with me to complete this project. Thanks
|
|
#2
October 8th, 2003, 07:20 PM
|
|||
|
|||
|
hi hln2003,
you can use "sum" like this Code:
select SUM(data) from TableName where region = 'A'
__________________
Hope this helps. Mike Royal Selangor Pewter "I have not failed. I've just found 10,000 ways that won't work." - Thomas Alva Edison (1847-1931)
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > ASP Programming > need help on subtotal line |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
