thanks, that took care of the error.

I still need to do a calculation on each on of the union/select tables. I may need to use a group by but...