Sum Not working?

[crimedog]

I have

Sum(IIf(IsNull([SalesOrder]) And [Approved]=True,1,0))

I would like it to count all records that do NOT have anything in [SalesOrder] And is [Approved] - this should be returning a number (there are some records that mtch the criteria) - But it is returning 0

Is there something I am missing?

[Bob Fitz]

I would create a calculated field in the forms record source query with something like:

Cal: IIf(IsNull([SalesOrder]) And [Approved]=True,1,0)

Then add a textbox to your form bound to the calculated field (Cal) and then do a simple sum of that in the Header or Footer

[pbaldy]

It could also be that your field isn't Null. Try

Sum(IIf(Nz([SalesOrder], "") = "" And [Approved]=True,1,0))

[crimedog]

Thanks guys - tried changing the formula and it worked.