COUNTING

[Guest]

I am having troubles counting in a report, I have zeros in a particular
field, cannot delete them, but I want to count everything without zeros.
Have tried count([fieldname]>1) doesn't work what am I doing wrong?

 

[Duane Hookom]

Count() will count all non-null values. Try:
=Sum(Abs([FieldName]<>0))

 

[Guest]

Thanks worked like a charm, what does abs mean?

Count() will count all non-null values. Try:
=Sum(Abs([FieldName]<>0))

--
Duane Hookom
MS Access MVP

I am having troubles counting in a report, I have zeros in a particular
field, cannot delete them, but I want to count everything without zeros.
Have tried count([fieldname]>1) doesn't work what am I doing wrong?

 

[Tom Lake]

Thanks worked like a charm, what does abs mean?

Abs is the absolute value. If a number is negative Abs makes it positive
otherwise it leaves it alone.

Since the test for <>0 returns -1 if true, you'd get the negative sum of the
field. The Abs insures the answer will be positive.

Tom Lake

 

[Guest]

Thanks works like a charm, but what does abs mean?

Count() will count all non-null values. Try:
=Sum(Abs([FieldName]<>0))

--
Duane Hookom
MS Access MVP

I am having troubles counting in a report, I have zeros in a particular
field, cannot delete them, but I want to count everything without zeros.
Have tried count([fieldname]>1) doesn't work what am I doing wrong?