Counting Records in a Qry

[Rlawson76]

I have a Qry which in one column calculates a result for each Record .

I would like to count the number of records which the result is greater than a value ie 5.

I have been trying to use a DCOUNT but i cannot seem to get it to work.

Does anyone have any ideas?

Thanks in advance

[MindBender77]

Have your tried changing the criteria in your count column to: > 5

Bender

[NeoPa]

Assuming the query is called [qryName] and the field with the result in is called [Result] then :

DCount("*", "[qryName]", "[Result]>5")