One Field total records count and percentage of null values

[navychief]

I would like to add to the bottom of my report total records, then compare it to total number of null values in one field, then give an over all percentage of those values that are not null. Now the truly important question is how do I do it? Care to enlighten me?

[June7]

An expression in textbox in footer:

=Sum(IIf(IsNull([fieldname]), 1, 0))

or

=Sum(IIf(IsNull([fieldname]), 0, 1))

[navychief]

Used the expression you typed. Tried both and both times come back with "The expression you entered is missing closing parenthesis, bracket (]), or vertical bar(I)"

[June7]

Sorry, need another ) at the end. I corrected the post.

[navychief]

=Sum(IIf(IsNull([Last KAS BOOK COMPLETED]),0,1) exact way I have typed it in

[navychief]

Tried it the corrected way =Sum(IIf(IsNull([Last KAS BOOK COMPLETED]),1,0)) and =Sum(IIf(IsNull([Last KAS BOOK COMPLETED]),0,1)) still not go. Do I need a space before zero and one?

[June7]

The spaces are irrelevant.

Same error message?

The textbox is in footer section?

[Last KAS BOOK COMPLETED] is a field in the RecordSource?

If you want to provide db for analysis, follow instructions at bottom of my post.