Thank you so much for replying!

The answer is now, so I have used that now which shows loads and loads of delivered and undelivered commands, so clearly data is...

Never knew about the LEAD function- thought I might have come across to the requirement to use this at least once before!!

Thank you so much, I know I...

Thank you so much, you have dug me out of a whole.

I will bear in mind the scripts to create the dataset in future as well.

Cheers!

Sorry my bad, the first table is just a temp table I have created listing the people and their visit dates - they are limited to 3 visits in this...

Thank you so much, worked perfectly!

Thank you both very much, that makes sense and totally solves my issue.

Really appreciated!