Worked my way through it and looks like I've got the solution more or less.  Thanks Phil for the Lead function...never used it before.  This more or less does what...

Thanks for your response! Actually I would just like the field to be added as a column but was thinking that the union could combine the data from the...