Append Query

[Buddha1]

I am trying to append a field in table A to a field in table B. Table B already has records in it however the first field is left blank. There are three fields in table A however I only want one of them to append to table B. Both table A and B contain two fields that have the same data, I only want the field from table A to append if the fields that the two tables have in common match. How can I do this?

 

[LittleSmudge]

You cannot Append FIELDS to a table ( least ways not in the way you mean ) you Append records

however, by the criteria you specify in your post you are not actually APPENDING at all you are UPDATING

Create an update Query based on the target table and put the matching two fields into the Criteria
Then add the third field at theone to update.



'ope-that-'elps.



G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.