How do I do this?

[sueviolet]

My problem:


A selection of records in 4 fields are incorrect (in a table of many fields)

I want to replace them with the correct records. (which I have in a separate table, consisting of only the corrected 4 fields)

How do I just replace the incorrect records?


Thanks for your time,


Sue

 

[ggreg]

if you can match the bad field with the good field in a query,

then you can do an update query....in the update to:
under the bad field
you put the table name of the [goodtable].[goodfield]
then run it but...................

make a copy of you db and run a test in the copy until
you got it to work right.

 

[sueviolet]

sorry, you lost me there - what do I do?

 

[ggreg]

first make a copy of your database,
Then make a query using the table with bad data field
and table with good data field put in critria bad data
run query to see if you are match up right if you are then
change the query to a update query....when you change
the query to an update query its going to have
a field call update to: under the table names
in the bad field you put :
[tablename].[gooddata]

and run it.
still need more help?

 

[ggreg]

Are you getting close Sue ? I had to remove the attachment
because I am heading home if it was helping will add one from
home when I get there

 

[sueviolet]

Thanks Greg

Thanks for all your help - you rock!


After some fiddling I finally got it figured out using your posts


Thanks again

Sue