Hi, thank you for the assist with the qry. I have had time review my data and have one question. when I see a null value in time2 is it possible to retrieve the next records time1 and use that inplace of the null?