Access Update Query Help

[csgraham74]

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

[jahoobob via AccessMonster.com]

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