Join same field on two tables

[wilsoch]

Forgive if this is really stupid. This is what I am dealing with in
terms as simple as I can come up with:

I have one table with multiple records (country names) and multiple
fields (over 20). I have a second table with that contains only a
limited number of records (all of which are also represented in the
other table) with only two fields (also represented in the other
table). I need to know if it is possible to make the information from
the second table "join" with the first table and display the data from
both tables in one column.

Does that make any sense?

 

[John Spencer]

You can combine data in one column using the concatenation operators.

Field: Combined: [Table1].[FieldA] & " " & [Table2].[FieldB]

You can put both tables in one query and then drag from table1.SomeField to
table2.someMatchingfield and then display records from both tables. If you
want to display all the records from one table and matching from the second
then double-click on the join line and select the appropriate option.



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Guest]

Do a Google search on UNION and UNION ALL queries.

 

[wilsoch]

Do a Google search on UNION and UNION ALL queries.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.







- Show quoted text -

Thanks much for the adivce. I'll give it a whirl.