Thanks John,

I implemented this today (after trimming it down quite a bit) and it worked.

Thanks for the reply - makes life a little easier...

Could you walk me through this?

Can I turn this into a stored procedure? If so, what do I need to add to it so that it will run?

Thanks,

Andy

This is just the way the table has been designed initially. We are going to be re-writing this. However, in the meantime, does anyone have a "step by step" solution.

Someone...