Hi Dwain,
Thanks very much for going to the trouble of setting this all out for me. I'm very new (well, very rusty after 15 years of non-use), to playing with SQL Queries again and any such help as this is a big step forward for me.
Very much appreciated. I'll test it out with my scenario when I get to the office tomorrow.
Cheers,
Wayne