See if this works:
SELECT FieldID, SUM( Total1 ) AS Total1, SUM( Total2 ) AS Total2 ;
FROM TableName ;
GROUP BY FieldID
>I want to do a SQL SELECT and I want to do a group and then many sums on fields that will be a part of that group.
>
>example:
>
>FieldId Total1 Total2
>1 2 3
>1 4 5
>2 3 2
>2 1 2
>
>the result that I would like to have after the select is
>
>FieldId Total1 Total2
>1 6 8
>2 4 4
>
>
>How do I do that?
Chris McCandless
Red Sky Software