Create a query that takes 2 columns and merge them into 1 (1 Viewer)

Hi,
It's been a long time since I've done much in Access, but I need to run a query and not quite sure how to build it.

I have a table in SharePoint that has 2 columns (email, and additional email).
There are times where emails in the first column is used, and times where emails in the second column is used.

I have created 2 queries that pull the info I need for each condition.

what I need to do now, is create a query that takes the results of these 2 queries and puts everything in 1 column. I need to use these emails in a report.

So basically I have this
query 1:
email column 1
email 1
email 2

query 2
email column 2
email zzz
email xyz

and I need a final result of this

All Emails
Email 1
email 2
email zzz
email xyz

Is a union query the way I need to go?

It would be good if you defined your Table Structure.

Await your reply.

It's a SharePoint list so it's only one 'table'
The 2 columns I have are 'email' and 'alternate email'

Sorry about the delay.

I don't use Union or Crosstabs so I can't help along those lines.

But what I would do is to create a Temp Table and append each Group. One at a time. 2 in all.

cdoyle said:

Hi,
It's been a long time since I've done much in Access, but I need to run a query and not quite sure how to build it.

I have a table in SharePoint that has 2 columns (email, and additional email).
There are times where emails in the first column is used, and times where emails in the second column is used.

I have created 2 queries that pull the info I need for each condition.

what I need to do now, is create a query that takes the results of these 2 queries and puts everything in 1 column. I need to use these emails in a report.

So basically I have this
query 1:
email column 1
email 1
email 2

query 2
email column 2
email zzz
email xyz

and I need a final result of this

All Emails
Email 1
email 2
email zzz
email xyz

Is a union query the way I need to go?

Click to expand...

Have you tried a UNION Query? It sounds like that would be a great start.