update table?

  • Thread starter Thread starter Jeff Lane
  • Start date Start date
J

Jeff Lane

I have two tables of about 3500 records each.
Table one contains a REG_NO column and an AREA column and is sparsley
populated in the AREA column.
Table two contains a REG_NO column and an AREA column and is fully populated
in the AREA column.
I want to populate the first table AREA column with the data from the second
table AREA column but only the fields that are empty because the second
table is slightly inaccurate.
If I can't populate only the empty fields I can live with the inacurracies,
but I still want to populate the first table from the second.

Help anyone? please?
 
Create the query with the two tables joined on the common
field REG_NO

Bring the AREA field from the sparsley populated table
into the design grid

Put the following two words into this fields Criteria row
Is Null

Then, change the query type to Update Query - use the
Query menu

Then put the following into the Update To row of the field
[tablenameoffullypopulatedtable].[AREA]

Then run the query - big red explanation point on your
toolbar.

You're done.
Lisa
 
Back
Top