Append Query

[Guest]

I have designed an append query to append all the records from 1 table to
another. Unfortunately, I missed 1 field in the append design. Is there any
way I can now append this missing data to the existing records without
duplicating data and records as I know this happens when you duplicate the
same append?
I dont really want to delete all the records and start afresh as I have made
many changes to the new table already, before I realised my error.

Thanks for any help
Roger

 

[John Vinson]

I have designed an append query to append all the records from 1 table to
another. Unfortunately, I missed 1 field in the append design. Is there any
way I can now append this missing data to the existing records without
duplicating data and records as I know this happens when you duplicate the
same append?
I dont really want to delete all the records and start afresh as I have made
many changes to the new table already, before I realised my error.

Thanks for any help
Roger

Use an Update query instead. Add the new field to the table in design
view (it will be null for all records). Join the new table to the
source table by the field (or combination of fields) which uniquely
identify the record (if your table doesn't have a Primary Key... maybe
it needs one; if it does, use it).

Change the query to an Update query and update the new field to

[oldtable].[fieldname]

using your own table and field name, of course. The brackets are
required (otherwise it will update the field to "oldtable.fieldname"
as a literal text string!

John W. Vinson[MVP]