Colin,
Just think how BRILLIANT it was of Michel to program this ability into the SEND button :-)

>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,