Sorry, but I'm not sure I follow... I'm learning a lot just from trying to understand what everyone here is suggesting.

Would you mind explaining a bit further how I might be able to put the two separate subqueries into one as part of an update statement?

Thanks!