'merge text fields in tables in a query'

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two tables and each table has a field called 'firstname' and have text
values in them. I want field in another table or query that displays
'firstname' values from both tables. how do i do it
 
If there is a linking field between the two, then add both tables to the
query, link the fields, and add the two fields to the query results.
 
I tried but it shows repeated names, how do I add two fields to the query
results, need help.
 
Back
Top