Hello,
There are two tables (tbl_Variants) and (tbl_Variant_qry) with identical fields (I verified that they are spelled correctly).
“tbl_Variant_qry” is created from make a table query and will be constantly updated (deleted and recreated)
I’ve created a query that should update records from tbl_Variant_qry to tbl_Variants if [aa_change] and [sample_id] are matching. I’m not sure if it’s important but most of the fields are blank in both tables.
When I run the query I get prompted to enter parameter value. Is this happening because most records in tbl_Variant_qry are blank and it’s asking me for input?
Thank, Mila
There are two tables (tbl_Variants) and (tbl_Variant_qry) with identical fields (I verified that they are spelled correctly).
“tbl_Variant_qry” is created from make a table query and will be constantly updated (deleted and recreated)
I’ve created a query that should update records from tbl_Variant_qry to tbl_Variants if [aa_change] and [sample_id] are matching. I’m not sure if it’s important but most of the fields are blank in both tables.
When I run the query I get prompted to enter parameter value. Is this happening because most records in tbl_Variant_qry are blank and it’s asking me for input?
Code:
UPDATE tbl_Variants SET tbl_Variants.Review_One = [tbl_Variant_qry].[Review_One]
WHERE (((tbl_Variants.aa_change)=[tbl_Variant_qry].[aa_change]) AND ((tbl_Variants.sample_id)=[tbl_Variant_qry].[sample_id]));
Thank, Mila