Append query?

[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

 

[Nikos Yannacopoulos]

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

 

[Van T. Dinh]

You want an Update Query, not Append. Append Query will append (new)
Records to the destination Table.

 

[Guest]

Thanks..woked much better with an update query..

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

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