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.