miller
Posts: 5
|
Posted: 03/08/2004, 11:58 AM |
|
I am using ASP 3.0 with Templates-MS Access 2002
I need to get the TOTAL of a field in search results, I have no clue and I have tried the Count Sheep example and everything but no luck.
Project Name: CarrierLookup
Grid Name: WebprosQuery
Field Name: PROAmount
Connection: Connection1
CCS: 2.2
I need to total up the PROAmount field.
Any help would be very much appreciated
Joo
_________________
Joe Miller
Simpleton |
|
|
DonB
|
Posted: 03/08/2004, 12:51 PM |
|
Put a SQL statement in your datasource
SELECT groupbycolumn, SUM(PROAmount) from sometable
GROUP BY groupbycolumn
Assuming you want to see several rows, with totals for each 'groupbycolumn"
(whatever the name might be)
--
DonB
http://www.gotodon.com/ccbth
"miller" <miller@forum.codecharge> wrote in message
news:6404cd07e7438d@news.codecharge.com...
> I am using ASP 3.0 with Templates-MS Access 2002
>
> I need to get the TOTAL of a field in search results, I have no clue and I
have tried the Count Sheep example and everything but no luck.
>
> Project Name: CarrierLookup
> Grid Name: WebprosQuery
> Field Name: PROAmount
> Connection: Connection1
> CCS: 2.2
>
> I need to total up the PROAmount field.
>
> Any help would be very much appreciated
>
> Joo
> _________________
> Joe Miller
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|