>In a table I have following fields:
>
>acno n(5)
>debit n(12.2)
>credit n(12.2)
>balance n(12.2)
>
>I want to count the number of debit entries for a particular acno. And to store the number.
>I failed to do so as I am not finding any idea to proceed. Please help.

COUNT TO myVar FOR accno = <myValue> AND debit <> 0