Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top