I tried as suggested above SELECT mrp_part, SUM(mrp_qty) as quantity, mrp_due_dateFROM vwMRPGrossReqFilteredGROUP BY mrp_part, mrp_due_date however, it doesnt summarise correctly due to the grouping of the part. I need to summarise IF part = 'A' and part = 'B' else just return the value of each individual part thus D 4 13/08/2012A 10 14/08/2012B 15 14/08/2012C 10 14/08/2012should look likePart Qty DateA 25 14/08/2012C 10 14/08/2012D 4 13/08/2012