Forgive me for being grumpy and I do appreciate your offer of help - really. But I thought my original post was clear. The table holds records for when a value changes. It is deemed to be the same value in between changes - and yes I want to identify the value of all items on all days. For the sake of argument lets say starting from 2014-06-01 to 2014-08-01 (using the records I've given you).

Any ideas?

btw it's not an audit table or any such thing.