May not be possible but I simply want to return results from two tables (both text fields) rather than having to create a separate query for each table. For example, suppose I have two customer lists: one called customer.name with customer names, email, etc.; the other called customer.companyname which has all the similar data. What expression would be useful to get a listing of both of these name fields? The other fields (email, phone, etc.) are named the same; only the name field is different.
I have a table of customer names, addresses, phones, etc. I have a 2nd table of company names, addresses, phones, etc. I can create a table/pivot table to bring in all the table information for each set separately, but I am looking for an expression to bring in both sets together. Linke some sort of AND function.