469,356 Members | 2,629 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,356 developers. It's quick & easy.

Copy a column from one table to another in MSaccess

112 100+
Hi,
I have two tables in that one table contain name id, name, categary etc.,
and other table contains name id, name but not categary. now i want to copy the categary column another table.
One table is contains unic data. But other table contains repeated data.
1st table is Address list of the customer
2nd table is Distribution list for every month.
So some time the distribution list contains the name id many times according distribution.

Here my question Now i want to add the categary according to name id

Imthiyaz
Nov 10 '06 #1
3 7976
PEB
1,418 Expert 1GB
Hi from Queries
Select New Query add the 2 tables The category table and this that should be updated

Create a join between the fields that are equal

Choose from Query Menu Update query

Select the filed that you want to update

Under this Field write down [Category]

Run the query
Nov 10 '06 #2
imtmub
112 100+
Select New Query add the 2 tables( The category table and this that should be updated= Where to enter this)

Create a join between the fields that are equal
This is i think relationship right!

Select the filed that you want to update
From where i need to select
Nov 10 '06 #3
imtmub
112 100+
Select New Query add the 2 tables( The category table and this that should be updated= Where to enter this)

Create a join between the fields that are equal
This is i think relationship right!

Select the filed that you want to update
From where i need to select
Thanks i got the result
Nov 10 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Melissa Kay Beeline | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.