Add data to an existing record

  • Thread starter Thread starter Raj
  • Start date Start date
R

Raj

I need some help in adding data from one table into
existing record. I have imported data from a spreadsheet
and I have added these columns to my existing table. Now
i need to add the data to my existing records in my
table. I have and unique id [equipmentid]in both tables,
I have 3548 records in my old table but only 107 will
need the new data added to the records how can I use a
query to add the new data in to the old records where the
[equipmentid] are the same.

Thanks
 
I use an update query. Create a query with both tables
joined by the [equipmentid]. Set the query type to Update
query and set any other criteria you need. You will need
to have a field in your existing table for the data to go
into. Put the field you want the data put into in your
query, and use the expression builder in the "Update to"
line of that field to select the field the data is coming
from. When you run the query, the records that match your
criteria should be updated with the data from the new
table. The other records should be left alone.

HTH
 
Amy.
Thanks you..
-----Original Message-----
I use an update query. Create a query with both tables
joined by the [equipmentid]. Set the query type to Update
query and set any other criteria you need. You will need
to have a field in your existing table for the data to go
into. Put the field you want the data put into in your
query, and use the expression builder in the "Update to"
line of that field to select the field the data is coming
from. When you run the query, the records that match your
criteria should be updated with the data from the new
table. The other records should be left alone.

HTH
-----Original Message-----
I need some help in adding data from one table into
existing record. I have imported data from a spreadsheet
and I have added these columns to my existing table. Now
i need to add the data to my existing records in my
table. I have and unique id [equipmentid]in both tables,
I have 3548 records in my old table but only 107 will
need the new data added to the records how can I use a
query to add the new data in to the old records where the
[equipmentid] are the same.

Thanks

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