How can I join two columns from different table into one in MS Access?

p_slim

New Member

Join Date: Sep 2010

Posts: 1

13th Sep 2010

Hi Guys, I have a questions. for example: i created 2 tables in MS Access as below:

Table 1
column A
1
2
3

Table 2
column B
4
5
6

How can I join 2 columns from different table to become 1 column in Table 3 ? like

Column C
1
2
3
4
5
6

Thanks in advance

Last edited by p_slim; 13th Sep 2010 at 06:58 AM..

« JMSJ_M_Scott_Resume2010A1.doc | Mail Merge using drop-down lists »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Outer Join SQL Server table with Access table, How ?	Bing	Microsoft Access External Data	2	11th Sep 2009 08:49 PM
Unbound dgv - save two of the columns to a join table	dbuchanan	Microsoft Dot NET Framework Forms	7	18th Apr 2008 02:59 AM
join two fields in the same table in Access	=?Utf-8?B?Ymx1ZXNreQ==?=	Microsoft Access	3	12th Jul 2007 01:08 AM
How do I join the data from 2 columns in the same table?	=?Utf-8?B?d2hhc3NpY2hpYw==?=	Microsoft Access	4	1st Apr 2005 04:53 AM
How many table can join by using Ms Access Query?	=?Utf-8?B?UmFjaGVs?=	Microsoft Access Getting Started	1	23rd Mar 2004 01:13 PM