count

[Guest]

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

 

[Guest]

Using code, dcount function

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

 

[Guest]

Thanks Ofer! It works great.

Mike

Using code, dcount function

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

 

[Guest]

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