>The COUNT(v_tmpart.ro) will not give the expected result if you have null values. Try COUNT(*). Also, you can simplify the AvgTime column to be AVG(v_tmpart.numdays). HTH
That didn't seem to work any different. Actually, it looks like every time I run this query it decides on a different multiple to count by. I just tested it again and all of my NumRo's values are multiples of 2 instead of 3...very strange. All I want is for it to count the # of entries that make up the "group". Each group is unique. The insurance column has duplicated entries, but with the insurance grouped first, then range it is a unique entry.
-Paul