Adding data
Posted: Fri Jul 06, 2007 4:31 am
Hi,
I got database table containg following fileds.
Product_code
Box
Qty
What I want to do is to display all the records from the data base groyp them according to Product_code and after every product I want to display sum of all Qty. say if we have three record in the table
Product_code Box Qty
ckone 2 4
ckone 3 10
armani 3 3
The select result should be like this:
Product_code Box Qty
ckone 2 4
ckone 3 10
total 14
armani 3 3
total 3
Please help me .
Thanks
I got database table containg following fileds.
Product_code
Box
Qty
What I want to do is to display all the records from the data base groyp them according to Product_code and after every product I want to display sum of all Qty. say if we have three record in the table
Product_code Box Qty
ckone 2 4
ckone 3 10
armani 3 3
The select result should be like this:
Product_code Box Qty
ckone 2 4
ckone 3 10
total 14
armani 3 3
total 3
Please help me .
Thanks