Thank you for the reply and query - this table could have thousands of values I was just trying to give you an IDEA of some of the values but the key is we ALWAYS want it to yield everything UP to the last - in the record? Will what you gave us work on more than just those four examples I gave you that are in the 'Sample" data section??