Updating a table

[Dowsey1977]

Hi,

I have 2 tables in a database. In one, 2 of the columns are blank, in the other, the same 2 columns are populated. What I want to be able to do is run a query that will copy all information from the populated table into the same columns on the unpopulated table.

Not all records have these 2 columns populated, so the query will need to match the names in the 2 forms and only update where the names match.

Hopefully clear.

Many thanks in advance,
Simon

 

[Joe4]

Take a look at using an Update Query (See Action Queries in Access help).

You essentially want to link your two tables in a query, then put criteria on the the blank fields (Is Null), then in the Update To field, enter the name of the column from the other table.