count records subform > 60days

[stargate]

Ive base my subforms recordset on a query which uses the datediff function to find the total days.

I have added a unbound field in the footer of the subform to calcuate the no of records greater than 60days and then pass the calculated value to another bound field on the main form.

All I need to know if what is the function I use to count the no records greater than 60 days.

=Sum([Days]>60)

Im getting a negative number when I use the less than symbol

 

[pbaldy]

If it's the correct number, you can simply wrap your formula in the Abs() function.

 

[boblarson]

Actually, I had that off, it would be:

=Sum(IIF([Days]>60,1,0))

 

[stargate]

Worked nicely! thanks guys..im in debted.