Combine Two Fields in a Query?

[Luke]

I have a table that includes Contact information with the following fields:



"EntityName, Contact1First, Contact1Last, C1Phone, C1Cell, C1Email, Contact2First, Contact2Last, C2Phone, C2Cell, C2Email""

I have created a query that uses expressions to combine the first and last names of Contact 1 and 2:
"Contact1: ([Contact1Last] & (", "+[Contact1First]))"
"Contact2: ([Contact2Last] & (", "+[Contact2First]))"

I want to create a query with an expression that will create a new field that combines both the Contact 1 and Contact 2 expressions. This is what it looks like now:

Contact1...........Contact2
Smith, John........Honan, Luke
Williams, Jim.......Sullivan, Pat

I want it to look like this:

Expression1
Honan, Luke
Smith, John
Sullivan, Pat
Williams, Jim

Does anyone know hwo I can do this? Thanks.

-Luke

[TheShabz]

SELECT Contact1 FROM tblEntity
UNION
SELECT Contact2 FROM tblEntity

Also, it's up to you but I try to get away from using + in my concatenations. Try:
Contact1: [Contact1Last] & ", " & [Contact1First]

The + works well enough for strings but you can run into issues when concatenating numbers with +, Access will add them together instead.