Subject | how to build a sum query |
---|---|

Author | Maurizio |

Post date | 2008-06-14T06:05:40Z |

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

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