I have a table of clients that has the client first name, last name, email address, spouse first name, spouse last name, and spouse email address. I have a query to list client first name, last name, and email address for all clients with an email address. I have another query to list all the spouse first name, spouse last name, and spouse email address for all records that have a spouse that has a spouse email address. I then manually combine these two query outputs in a spreadsheet.
I’d like to have one query that lists everyone that has an email address into 3 fields, first name, last name, and email address. So the query output field (column) for first name, would have the client first names and the spouse first name all in that one column, and the same for last name and email addresses. Don’t care about order or connections between client and spouse. Just trying to get an email list of everyone in the table that has an email address so I can import it into my email app (Thunderbird).