Hi Paul

Many thanks for your response - that's seems to work exactly as I wanted it to. I will do some extensive testing now before I roll the solution out to the users.

Thanks again.

Greg - apologies for not responding to you sooner. Paul's solution was nearer to what I needed and appears to appears to work as I need it to.
Thanks again.

Kind regards

Tony