Many thanks for this. I've added your code to my page and it certainly displays the record.
Still to do:
At the moment I only have one list in the database so I need to populate it with at least a couple more. Then, presumably, I have to wait 7 days to see if the list changes? Or is there a quicker way to test?
Also, another question: If the client decides that he wants the list to change every two weeks? Will changing 7 to 14 do it? Again if every other day is wanted will changing 7 to 2 do it? Actually that's probably going answer the first question as well (is there a quicker way to test). I suppose I can experiment with that. I'll report back once I have "had a go".
I haven't given up with you. It's just that I wonder about the number of lists (rows) and how that would relate to week numbers.
Many thanks to both of you I really do appreciate your help.