Formula

[Guest]

I am having problems with a formula - I did not write it originally and am
not very skilled at formula's either. Does something appear to be missing?

=IIf([blocktotal]=0,[Sum Of SumOf# of Contracts1],([Sum Of SumOf# of
Contracts1]-[blocktotal])+[NF Blocks]![actual])

-
-
Bonni

 

[Guest]

Crude explanation:

If [blocktotal] equals zero then return the value in the textbox [Sum Of
SumOf# of Contracts1]
Otherwise return the value [Sum Of SumOf# of Contracts1]-[blocktotal]+[NF
Blocks]![actual]

Is there a textbox called [actual] in a subform called [NF Books]?

There is a syntax error though, I think it should be:
=IIf([blocktotal]=0,[Sum Of SumOf# of Contracts1],[Sum Of SumOf# of
Contracts1]-[blocktotal]+[NF Blocks]![actual])

Ray