You missed two closing parenthesis (in RED)
Code:
UPDATE ProfileData, SummaryTable
SET ProfileData.CarValueO1 = IIF( SummaryTable.NumberDrivers = "NumberDrivers1" AND SummaryTable.NumberClaims ="NumberClaims1") , [Total]*[CarValue] , CarValueO1 ),
ProfileData.CarValueO2 = IIF( SummaryTable.NumberDrivers = "NumberDrivers2" AND SummaryTable.NumberClaims ="NumberClaims2") , [Total]*[CarValue] , CarValueO2 )
WHERE ((SummaryTable.CarType)="Sedan");
Try this
Code:
UPDATE ProfileData, SummaryTable
SET ProfileData.CarValueO1 = IIf([SummaryTable].[NumberDrivers]="NumberDrivers1" And [SummaryTable].[NumberClaims]="NumberClaims1",[Total]*[CarValue], CarValueO1), ProfileData.CarValueO2 = IIf([SummaryTable].[NumberDrivers]="NumberDrivers2" And [SummaryTable].[NumberClaims]="NumberClaims2",[Total]*[CarValue], CarValueO2)
WHERE (((SummaryTable.CarType)="Sedan"));