By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,641 Members | 1,123 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,641 IT Pros & Developers. It's quick & easy.

Union Query Needed

P: 4
Hi, I have 2 tables in Access that I would like to join. They both have a Item No Field and a Description Field. However, Table A has a blank descrption field for some item #'s and these descriptions are found in Table B.

I want to union Table B and Table A so that Table A has all the now completed records from Table B.

Does this make sense?

I can't seem to get a query so that it doesn't create duplicate records of the Item #'s.

Ex.
Table A
Item No. Description
1 aaa
2
3
4
5

Table B
Item No. Description
3 kkk
4 lll

Resulting Table:
1 aaa
2
3 kkk
4 lll
5

Thanks!
Jun 5 '07 #1
Share this Question
Share on Google+
3 Replies

Rabbit
Expert Mod 10K+
P: 12,441
Hi, I have 2 tables in Access that I would like to join. They both have a Item No Field and a Description Field. However, Table A has a blank descrption field for some item #'s and these descriptions are found in Table B.

I want to union Table B and Table A so that Table A has all the now completed records from Table B.

Does this make sense?

I can't seem to get a query so that it doesn't create duplicate records of the Item #'s.

Ex.
Table A
Item No. Description
1 aaa
2
3
4
5

Table B
Item No. Description
3 kkk
4 lll

Resulting Table:
1 aaa
2
3 kkk
4 lll
5

Thanks!
Sounds like you're looking for an update query and not a union query.
Jun 5 '07 #2

P: 4
ah, great! Thanks! :)
Jun 6 '07 #3

Rabbit
Expert Mod 10K+
P: 12,441
Good luck. Let us know if you run into trouble.
Jun 6 '07 #4

Post your reply

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