Append query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

Have a table with about 25000 records. In this table I miss all data in one
single field.

I want to move data from the corresponding field in my backup table.

I made an Append query for this, when I run it (it runs without errors) but
is not updating the ohter table with any data.

By the way I have other append queries that works fine in those I choose *
all fields from one table to * all fields in the other table.

Mattias
 
Mattias,

What you need in this case is an Update query, not an Append one. Join
the two tables on the PK field(s) in a query, change its type to Update
(Query > Update) and set the Update To for the field to be updated to
the name of the field in the backup table. If the two fields have the
same name, then precede the field name with the table name so Access can
tell which one, like:

[BackupTableName]![FieldName]

HTH,
Nikos
 
You want an Update Query, not Append. Append Query will append (new)
Records to the destination Table.
 
Thanks..woked much better with an update query..

Mattias

Nikos Yannacopoulos said:
Mattias,

What you need in this case is an Update query, not an Append one. Join
the two tables on the PK field(s) in a query, change its type to Update
(Query > Update) and set the Update To for the field to be updated to
the name of the field in the backup table. If the two fields have the
same name, then precede the field name with the table name so Access can
tell which one, like:

[BackupTableName]![FieldName]

HTH,
Nikos
Hi

Have a table with about 25000 records. In this table I miss all data in one
single field.

I want to move data from the corresponding field in my backup table.

I made an Append query for this, when I run it (it runs without errors) but
is not updating the ohter table with any data.

By the way I have other append queries that works fine in those I choose *
all fields from one table to * all fields in the other table.

Mattias
Click to expand...
Click to expand...
 
Back
Top