Update from one table to another

[davea]

Hi

I am trying to use an update query to copy data from one column in a
table to another column in a different table. Both fields are called
DESCRIPTION in both tables. The two tables are linked using an auto ID
number generated by one table and have a one-to-many relationship.

Tables are called:

LINKED DESCRIPTION
LINKED QTY ID (data copied to this table)

I have set up an update query as follows:

Field: DESCRIPTION
Table: LINKED QTY ID
Update To: [LINKED DESCRIPTION].[DESCRIPTION]

When I view the query the field I want the data copied into is blank
for every record and so the query isn't coping any data at all.

Any ideas how I can do this?

 

[dneagle via AccessMonster.com]

Hi

I am trying to use an update query to copy data from one column in a
table to another column in a different table. Both fields are called
DESCRIPTION in both tables. The two tables are linked using an auto ID
number generated by one table and have a one-to-many relationship.

Tables are called:

LINKED DESCRIPTION
LINKED QTY ID (data copied to this table)

I have set up an update query as follows:

Field: DESCRIPTION
Table: LINKED QTY ID
Update To: [LINKED DESCRIPTION].[DESCRIPTION]

When I view the query the field I want the data copied into is blank
for every record and so the query isn't coping any data at all.

Any ideas how I can do this?

You use an APPEND query, not an update query. Also, the ID should ot be an
autonumber in the receiving table.

 

[John Spencer]

Are you running the query? Select Query: Run from the menu. Simply
switching the view from Design view to Datasheet view does not do the
update, it will show you the records that would be updated if you ran the
query.

 

[davea]

Cheers guys,

Got it working with an update query. My system was taking over 10 mins
to run the query! Not that many records were getting updated so not
sure why it was taking so long.