Is it possible to append only a few selected cells of a a few selected records?

[Darth_VBA]

This is racking my brain and I can't seem to find the answer from earlier posts.

I created a "find unmatched" query, built to show me that a status (Avail_ID) has changed from my data source.

I then want MS Access to only update the records and the specific unmatched cell on my DB table.

The SQL for the find unmatched query is:

SELECT qryvsbwithkey.Key, qryvsbwithkey.[Avail ID]
FROM qryvsbwithkey INNER JOIN BAWP ON qryvsbwithkey.[Key] = BAWP.[Key]
WHERE (((qryvsbwithkey.[Avail ID])<>[BAWP]![Avail_ID]));

Is there a way to now change this query into an append query that will change [BAWP]![Avail_ID] to the value in qryvsbwithkey.[Avail ID], for only the results of the above query?

[Welshgasman]

I'd just create a select query using your unmatched as the source. Then change that to an append query, all within the query designer?

[Micron]

I then want MS Access to only update the records

You don't change data by appending - you update. An update query using the unmatched query as the source?

[Darth_VBA]

Thank you all for your replies.

I realize now I wanted to update, and not append.

After some fumbling around, I ended up figuring out the sequence.

UPDATE BAWP INNER JOIN qryvsbwithkey ON BAWP.[Key] = qryvsbwithkey.[Key] SET BAWP.Avail_ID = qryvsbwithkey.[Avail ID]
WHERE (((qryvsbwithkey.[Avail ID])<>[BAWP].[Avail_ID]));

[Micron]

Best part is that you figured it out!