Hi George,

Thanks for the reply. Is it just me or does the Send button have the magic ability to illuminate the answer after being clicked :-)

SendButton.Click
       REPLACE Brain.Question WITH Answer
       ThisBody.SmackForeheadWithHand()

>>I have a table contains a project code, job code and quantity. I need to generate a result set that will show, uniquely, job codes that are used in any project and the total quantity of that job code across all projects. i.e.
>>
>>projectcode jobcode quantity
>>AAAAAAAA A1 5
>>BBBBBBBB A1 4
>>CCCCCCCC A1 1
>>
>>This would generate a result set of: A1 10
>>
>>Any suggestions greatly appreciated.
>Hi Colin,
>
>Use:

>SELECT jobcode, SUM(quantity);
>  FROM whatevertable;
>  GROUP BY jobcode;
>  INTO CURSOR foo

>hth,