Update Query Not Working Yet

[goslincm]

Good morning,I thought I had this query working but something is wrong yet and I cannot see what it is.

UPDATE Year3TempDistressFactors SET Year3TempDistressFactors.5Score = IIf(isnull(Yr1GeneralFundRevenue) Or isnull(Yr1GeneralFundExpenditure),Null,IIf(Yr1GeneralFundRevenue-(Yr1GeneralFundExpenditure/Yr1GeneralFundRevenue)<-0.01,1,0));


Its not returning the expected score correctly yet.

 

[Golom]

OK ... but what is wrong exactly?

What values do [blue]Yr1GeneralFundRevenue[/blue] and [blue]Yr1GeneralFundExpenditure[/blue] have in the record and what is [blue]5Score[/blue] getting as a value?