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