hi , i would like to know if possible , and how ,
to do this :

the table i have :

col_test | value | Part
y 2 aa
x 4 cc
y 10 cc
y 7 cc
x 2 aa
x 4 aa
x 5 cc
y 7 aa

a query should sum the 'value' column , but test the value of the
'col_test'
column : for the 'y' value put the sum in a field , for the 'x' in
another field :

result should be :

Part | sum_y_values | sum_x_values
aa 9 6
cc 17 9

thanks

Mauro