Append or Update which one do it use?????

[chubby]

I'm trying to replace the Date Of Birth column from table (A) with the Date Of Birth from table (B). Both tables are joined by SSN and matchup perfectly. Their are a few different columns but they both contain DOB.
I tried using update but I screwed up the whole date of birth column in table (A). What am I doing wrong? How can I fix this problem?
Thanx...

 

[tlbroadbent]

It is immensely helpful when asking for help with queries to post the query in question.

The Access SQL syntax will be:

UPDATE tblA INNER JOIN tblB ON tblA.SSN=tblB.SSN
SET tblA.DOB=tblB.DOB
WHERE tblA.DOB<>tblB.DOB Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.

 

[chubby]

Sorry, but my query was using the QBE not SQL... Thanks for the help...

 

[Chance1234]

You can get the SQL from the QBE. on the Query design toolbar the control on the far left lets you select design view, datasheet view and SQL