Formula not working 3

[istone]

Hi,
can anyone tell me why this formula is not working. I get a blank column.
Thanks

Total Amount: IIf([BP BILLED TO]="PLAN ASSETS" And [QRT BILLED TO]="INVOICE" And [Morningstar Sentence after Total]=Null,nz([MaxOfMaxOfTotal Fee Amount])-nz([MaxOfQRTRLY FEE])-nz([Momingstar Clearfuture Per Par Fee$100/part/month]))

 

[PHV]

Replace this:
=Null
with this:
Is Null

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Crowley16]

you can't use = null

use is null instead or isnull(column)

--------------------
Procrastinate Now!

 

[istone]

correction,

the formula should be:

Total Amount: IIf([BP BILLED TO]="PLAN ASSETS" And [QRT BILLED TO]="INVOICE" And [Morningstar Sentence after Total]=isnotNull,nz([MaxOfMaxOfTotal Fee Amount])-nz([MaxOfQRTRLY FEE])-nz([Momingstar Clearfuture Per Par Fee$100/part/month]))

 

[dhookom]

As per the previous nudges as well as always being explicit with the second argument of Nz(). I never leave the if null argument of Nz() to chance.

Total Amount: IIf([BP BILLED TO]="PLAN ASSETS" And [QRT BILLED TO]="INVOICE" And [Morningstar Sentence after Total] is not Null,nz([MaxOfMaxOfTotal Fee Amount], 0)-nz([MaxOfQRTRLY FEE], 0)-nz([Momingstar Clearfuture Per Par Fee$100/part/month], 0))

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[PHV]

So, replace this:
=isnotNull
with this:
Is Not Null

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[istone]

Got it. Thank you all.
dhookom, you were right adding the 0 after NZ() worked.