count

Mike · Oct 6, 2005

I would like to count all the values higher then 95 in a column and divide it
be all the values in that same column. Example:

98
100
94
98

to get 75% was 95 or higher.

Can someone help?

Thanks,
Mike Chamis

Ofer · Oct 6, 2005

Using code, dcount function

Dcount("*","TableName","FieldName > 95") / Dcount("*","TableName")

Mike · Oct 7, 2005

Thanks Ofer! It works great.

Mike

Ofer said:
Using code, dcount function

Dcount("*","TableName","FieldName > 95") / Dcount("*","TableName")

Ofer · Oct 7, 2005

you're welcome, I'm glad it worked out