Copying column from one table to another table

[curosity]

Hi,

I am new to MS access.
Can anyone please help me in MS access?

Query:
I have two tables : Table1,Table2.
Table1 has columns : A,B
Table2 has columns: A,C

What I want to do is to copy all data of "C" from Table2 to Table1 so that Table1 has columns: A,B,C

(Column "A" is common in both Tables).

Thanks

 

[Catalina]

You should be able do this with a Make Table Query and combine the two using
the common A field as a relation into a new table.

Check this out:
http://office.microsoft.com/en-us/access-help/create-a-make-table-query-HA010108505.aspx#BM1

Catalina

 

[Rabbie]

Why do you need the data in two tables? Why not have one table with fields A,B,C.

 

[curosity]

Hey Catalina, thank you for the help. It worked.

@Rabbie - yes, I wanted to keep all information in one table, thats why wanted to copy it from Table2 to table1.

 

[Catalina]

You're welcome, I'm glad you got it done.

Catalina