Thank you that is a great idea. 

I have a question about this part though

"you will also have to change your parameter to use a list of values sepparated...

Thank you for the help both on this post and my previous one the sql part of the project is done for now

Cory Lee McRae

Ok thanks to vishy and all who responded new code works.

 this is what I have are there ways to make it better

select  BLOCK_ID

 ,DENSITY

 ,AVG_THICK

 ,(select sum(AVG_THICK)

   from dbo.THICKNESS_TABLE y

  where y.[TIME] ...

One of the reason the query didn’t look right is it wasn’t.  I tried many different things and didn’t clean it up right sorry.  I...