Hi.

I am trying to write a union query and need help.

I have a table containing 6 fields Name1,Name2, Name3, Name4, Name5, Name6. I want to produce a single drop-down list of all these names, and don't know how to write the UNION SQL statement for it.

Can anyone please help

Thank you in advance

Ruby

Please continue with the same thread so members can follow. On reflection I'm not sure a Union will work and I'm wondering why you actually need to do this. There would seem to be a design problem here. Please post back with more details of your table design.

Hi rich

thank you for getting back to me. I do actual have a design problem. So please ignore this.

Ruby