Average of count

[Karen831]

I have a query with a check date field. In any given month, there could be 2-3 checkdates. I need the average, per month, of the number of checks issued. Can anyone help me do this in an Expression...

 

[dcobau]

try something like the following:

SELECT Avg(IIf([ckField]=-1,CInt(1),CInt(0))) AS CountField
FROM tblTableName;

Dave