Sorry davey23uk

That just reorders them - I need to fill the null values as demonstrated in my post.

I'm beginning to doubt if this can be done without adding more info to the table, maybe load it into a temp table and add an id column to it.

Any ideas?

j