how to not show zero's

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

Guest

I am using a iif statement in my Report, that says
iif([fieldname]>1,sum([fieldname]),null). I don't get true readings on this
because if I don't do the iif just sum([fieldname]) I get more numbers the
field is a number field but should it be a double or long integer? or is
that what the problem is? Thanks
 
I am using a iif statement in my Report, that says
iif([fieldname]>1,sum([fieldname]),null). I don't get true readings on this
because if I don't do the iif just sum([fieldname]) I get more numbers the
field is a number field but should it be a double or long integer? or is
that what the problem is? Thanks
Click to expand...

Try:
=Sum(IIf([FieldName]>1,[FieldName],0))
 
Thank you Fred works like a dream when you do it right!

fredg said:
I am using a iif statement in my Report, that says
iif([fieldname]>1,sum([fieldname]),null). I don't get true readings on this
because if I don't do the iif just sum([fieldname]) I get more numbers the
field is a number field but should it be a double or long integer? or is
that what the problem is? Thanks
Click to expand...

Try:
=Sum(IIf([FieldName]>1,[FieldName],0))
Click to expand...
 
Back
Top