|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
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
|
|||
|
|||
|
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 |
|
|
|
|