M
Mykas_Robi
Unable to run a query that I've ran numerous times in the past. The only
thing that has changed is the table structure (added new fields that I am not
updating.) syntax of query is below
UPDATE DISTINCTROW [pri2 struc], [rate table 0607 3] SET [pri2
struc].[PRIMARY PREMIUM] = [rate table 0607 3].[PRIM PREMIUM]
WHERE ((([pri2 struc].[CLASS CODE])=[rate table 0607 3].[CLASS CODE]) AND
(([pri2 struc].COVERAGE)=[rate table 0607 3].[COVERAGE]) AND (([pri2
struc].[PRIMARY LIMITS])=[rate table 0607 3].[PRIM LIMITS]) AND (([pri2
struc].[CM YEAR])=[rate table 0607 3].[YR]));
please note. it works on a table that i created a year ago but doesn't work
on the new table. it only updates where coverage=SCM and cm year = 1.
please help
thing that has changed is the table structure (added new fields that I am not
updating.) syntax of query is below
UPDATE DISTINCTROW [pri2 struc], [rate table 0607 3] SET [pri2
struc].[PRIMARY PREMIUM] = [rate table 0607 3].[PRIM PREMIUM]
WHERE ((([pri2 struc].[CLASS CODE])=[rate table 0607 3].[CLASS CODE]) AND
(([pri2 struc].COVERAGE)=[rate table 0607 3].[COVERAGE]) AND (([pri2
struc].[PRIMARY LIMITS])=[rate table 0607 3].[PRIM LIMITS]) AND (([pri2
struc].[CM YEAR])=[rate table 0607 3].[YR]));
please note. it works on a table that i created a year ago but doesn't work
on the new table. it only updates where coverage=SCM and cm year = 1.
please help