davidwu
Posts: 5
|
Posted: 06/21/2006, 11:54 PM |
|
I built a table using SQL in the VQB, and the output seems to be perfectly fine.
But my problem is, if lets say, I had a column called cost, and at the end of very bottom of the table, I wanted to calculate the TOTAL cost by adding up all the values of the field "cost", how would I go about doing that?
I know how to create a new table that allows me to calculate the TOTAL cost of each field. But if I wanted the total cost to be at the bottom of the exisiting table, how would I approach this?
I tried to insert a grid within the existing table, but CodeCharge doesn't let me place a grid within another grid.
So I'm kinda stuck......
|
|
|
mrachow
Posts: 509
|
Posted: 06/22/2006, 12:26 AM |
|
See CCS manual
Examples and Techniques
paragraph
Programming | Simple Report with Total
_________________
Best regards,
Michael |
|
|
davidwu
Posts: 5
|
Posted: 06/22/2006, 2:32 AM |
|
Nice, I got it working.
Thanx mrachow
regards
David
|
|
|
|