Merge two columns into one, but with unique values

Anonymous ,

I would approach it this way:

1) Copy your first query to create a second one.

2) In the first query, delete column 2.  Rename Column 1 to New Column

3) In your second query delete Column 1. Rename column 2 to New Column

4) Use the Append Queries function to append these columns together.  I would choose "Append Queries as New"

5) Then you can delete the first two queries.

Hope this or some alternative to this will help you get on your way.  There may be a cleaner solution, but I thought that I'd at least throw this idea ou to you.

Regards,