Re: Access long expression - parenthsis problem

Thank you, i got my expression worked.

Michelle

"JasonF" wrote:

You would be much better off creating a custom function for this in
VBA rather than using an if statement. However, here's my shot at the
parentheses problem:

IIf(
(
Round(
(
nz([RuralMill06])*(
(nz([SumOfLand06]))+nz([NetBldgAssess06])
)+nz([ResiRuralMill06])*(
nz([NetResiBldgAssess06])+nz([SumOfResidentialLand06])
+nz([SumOfRuralLand06])
)
)*0.001,2
)<1 and
Round(
(
nz([RuralMill06])*(
(nz([SumOfLand06]))+nz([NetBldgAssess06])
)+nz([ResiRuralMill06])*(
nz([NetResiBldgAssess06])+nz([SumOfResidentialLand06])
+nz([SumOfRuralLand06])
)
)*0.001,2
)>0
),1,iif(
Round(
(
nz([RuralMill06])*(
(nz([SumOfLand06])
)+nz([NetBldgAssess06])
)+nz([ResiRuralMill06])*(
nz([NetResiBldgAssess06])+nz([SumOfResidentialLand06])
+nz([SumOfRuralLand06])
)*0.001,2
)=0,0,IIf(
Round(
(
nz([RuralMill06])*(
(nz([SumOfLand06])
)+nz([NetBldgAssess06])
)+nz([ResiRuralMill06])*(
nz([RoundResiBldgAssess06])+nz([SumOfResiLand06])
+nz([SumOfRuralLand06])
)*0.001,2
)>1,Round(
(
nz([RuralMill06])*(
(nz([SumOfLand06]))+nz([NetBldgAssess06])
)+nz([ResiRuralMill06])*(
nz([NetResiBldgAssess06])+nz([SumOfResiLand06])
+nz([SumOfRuralLand06])
)
)*0.001,2
),'error'
)
)
)


.

Relevant Pages