Thank you for the hint! I've tried several complicated formulas to try to get this to work because I didn't think MIN/MAX would work for this. Although I can't...

oh and I ran that query and it says 'Nothing' under that column

The recovery mode is Full and I have a tran log backup running nightly so it will truncate the log. I would put it in Simple mode and will...