>So your data is not normalized? < gd&r >


Everybody's gotta be a comedian!:-)
>
>>>
>>>George,
>>>The workaround is to add the stockcolor field to the Group By clause, IMO. ;-)
>>
>>< bg >Not if you just want the totals for each sku.:-)