SUMM recorset fileds and recopy in listview1

sal21 · February 5th, 2009, 04:18 AM

Note: i use the tipical ADO conn.
In the excel file are a table structure and a listview1 structure.
Now i want to select dinstinct based CAMPO1 and recopy in listview1 but with total summ of CAMPO6...
Result is in listview1 in excel file attached.

TABLE CAMPO1CAMPO2CAMPO3CAMPO4CAMPO5CAMPO6AAAATEST1TEST2TEST3TEST4100,00AAAATEST1TEST2TEST3TEST414.587,00BBBBTEST1TEST2TEST3TEST41.478,00CCCCTEST1TEST2TEST3TEST42.589,00BBBBTEST1TEST2TEST3TEST424.589,00AAAATEST1TEST2TEST3TEST4147,00

RESULT IN LISTVIEW1CAMPO1CAMPO2CAMPO3CAMPO4CAMPO5CAMPO6AAAATEST1TEST2TEST3TEST414.834,00BBBBTEST1TEST2TEST3TEST426.067,00CCCCTEST1TEST2TEST3TEST42.589,00

gbianchi · February 5th, 2009, 08:10 AM

Hi there.. can you please try to reformat your post, so we can see what are you actually trying to do?

Thanks.

(I think and I can assume that you want something like "SELECT SUM(campo6) FROM table GROUP BY campo1")

sal21 · February 8th, 2009, 04:53 PM

Quote:

Originally Posted by gbianchi

Hi there.. can you please try to reformat your post, so we can see what are you actually trying to do?

Thanks.

(I think and I can assume that you want something like "SELECT SUM(campo6) FROM table GROUP BY campo1")

Hi gbianchi (i dont know your really name)...
Is exactly wath i want.
Tks!

gbianchi · February 8th, 2009, 06:18 PM

Gonzalo is my name. and no prob.