Append Query

  • Thread starter Thread starter Steve Smith
  • Start date Start date
S

Steve Smith

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
 
First APPEND queries add new records. UPDATE queries change existing
records.

Which are you trying to do?


Please copy and post the SQL of your SELECT query. It may give someone
sufficient information to help you. (also, could you tell us which fields
are field 2 and field 3?

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message
 
Back
Top