Probably an eaasy one! Please Help??!

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

Guest

I would like to calculate a running sum of a field where the values in that
field are Null. I have the basic expressions for a sum to be calculated when
the field is not Null i.e.:

=IIf([WI Progress] = "Completed",1,0)

Any help would be greatly appreciated, I'm sure its an easy one!!
Cheers
 
Well, the example you give will handle Nulls as 0. I suspect you are trying
to add a number field where the IIf statement isn't needed. If so, and you
want 0 added if the value is Null try:

=Nz([FieldName], 0)
 
Doesn't work. Sorry, let me explain further. I have a text field that
displays the progress of a project i.e. Completed/In Progress/"Null". I have
a list of projects that aren't completed i.e. "Null" in a report, as the
report footer I would like to see "Total Not Completed: ???".
Cheers

Wayne Morgan said:
Well, the example you give will handle Nulls as 0. I suspect you are trying
to add a number field where the IIf statement isn't needed. If so, and you
want 0 added if the value is Null try:

=Nz([FieldName], 0)

--
Wayne Morgan
MS Access MVP


A. Smart said:
I would like to calculate a running sum of a field where the values in that
field are Null. I have the basic expressions for a sum to be calculated
when
the field is not Null i.e.:

=IIf([WI Progress] = "Completed",1,0)

Any help would be greatly appreciated, I'm sure its an easy one!!
Cheers
Click to expand...
Click to expand...
 
Not to worry I've just sorted it! I replaced your 0 for a 1, silly me!
Cheers Wayne

Wayne Morgan said:
Well, the example you give will handle Nulls as 0. I suspect you are trying
to add a number field where the IIf statement isn't needed. If so, and you
want 0 added if the value is Null try:

=Nz([FieldName], 0)

--
Wayne Morgan
MS Access MVP


A. Smart said:
I would like to calculate a running sum of a field where the values in that
field are Null. I have the basic expressions for a sum to be calculated
when
the field is not Null i.e.:

=IIf([WI Progress] = "Completed",1,0)

Any help would be greatly appreciated, I'm sure its an easy one!!
Cheers
Click to expand...
Click to expand...
 
Back
Top