I'm using the following Update query to update two fields form tbl_cnv_qry table to tbl_CNVs table, for records that have the same sample_id.
UPDATE tbl_CNVs INNER JOIN tbl_cnvs_qry ON tbl_CNVs.ID = tbl_cnvs_qry.ID SET tbl_CNVs.First_Rev = [tbl_cnvs_qry].[First_Rev], tbl_CNVs.Second_Rev = [tbl_cnvs_qry].[Second_Rev]
The query is no longer updating the values for some reason.
I'm attaching a sample Access file Test.zip.
Please suggest how to improve the query so it works.