I have a database with 20 fields, and a several hundred records.  In six
records, field2 contains an abreviation, and field3 contains the full word
for the abreviation - all other fields blank.  In the remaining records,
field3 contains any one of the 6 abreviations found in field2, and all other
fields are full with data.

I have created a select query that displays just the field 2 and field 3 for
the 6 records.  I am then trying to create an append query that takes the
value of the abreviation in the select query, field2, compares it to the
content of field3 in the main data, and if it is the same, replace the
content of field3 in the main data with the value of field3 in the select
query.

Have been going round in circles so has anybody got any suggestions.

Thanks in anticipation.

Steve