hello guys! need some help please
i have a table on Microsoft access and i would like to use update query to update a column. but instead of creating so many queries i want it to be one query.
i tried to do it like the query below but it didn't work. can anyone help please?
UPDATE vouchers SET vouchers.[InsuranceName ] = "CHPW"
WHERE (((vouchers.PAYOR)="MCR MCO") AND ((vouchers.Insurance_name) Like "**CHPW**"));
UPDATE vouchers SET vouchers_.[InsuranceName] = "Amerigroup"
WHERE (((vouchers.PAYOR)="MCR MCO") AND ((vouchers.Insurance_name) Like "**Amerigroup**"));
i have a table on Microsoft access and i would like to use update query to update a column. but instead of creating so many queries i want it to be one query.
i tried to do it like the query below but it didn't work. can anyone help please?
UPDATE vouchers SET vouchers.[InsuranceName ] = "CHPW"
WHERE (((vouchers.PAYOR)="MCR MCO") AND ((vouchers.Insurance_name) Like "**CHPW**"));
UPDATE vouchers SET vouchers_.[InsuranceName] = "Amerigroup"
WHERE (((vouchers.PAYOR)="MCR MCO") AND ((vouchers.Insurance_name) Like "**Amerigroup**"));