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

Access Update Query Help

P: n/a
Hi Guys,

I was wondering if someone could help me with an access query.

I basicallly have two tables A & B

Im table A there are numerous records with Fields1 & fields 2

I want to use table B to update table A. Bascically i need to compare
table A & Table B - if records exist in Table B that are not in Table A
then i need to update table A with the appropriate records.

any help appreciated

Thanks

C

Aug 8 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Why the redundancy? If you have exactly the same data in B as A there is no
need for B.
That being said, and if you insist, I believe you can create an Unmatched B
in A query and make it an update query to A.

csgraham74 wrote:
>Hi Guys,

I was wondering if someone could help me with an access query.

I basicallly have two tables A & B

Im table A there are numerous records with Fields1 & fields 2

I want to use table B to update table A. Bascically i need to compare
table A & Table B - if records exist in Table B that are not in Table A
then i need to update table A with the appropriate records.

any help appreciated

Thanks

C
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200608/1

Aug 8 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.