Thanks for you help guys - brilliant!

Mark

Hi Bob,

Great script!  That is exactly what I needed.

I am actually completing the sum as part of a cross table or pivot selection. Using:

SELECT  SUM(CASE item_grp WHEN 'A' THEN item_value...