YeeHa !

that's it! Thank you Hilmar. I tried yesterday, and tried and tried, and just could not get it to work. I feel stupid, it looks so simple.

thanks again!

>
>Use GROUP BY, for instance:
>
>

>select Customer, Month, sum(usell*qtyord) as Amount;
>  from Cur_Temp;
>  into Cur_Temp2;
>  group by Customer, Month
>

>