Totalling in main form

[edwardcga]

I want to do a count in the subform of payment type (Payment type are "visa","cash",chq") and call the total in the main form. I use DCOUNT it counted the whole DB. I want to restrict the count to the CURRENT form record with no. of counts in subform. How can I accomplish this. Which function should I use or I need a VBA. Please advise.

Thanks

EW

[June7]

If the subform is in Continuous view, use textbox in subform footer section: =Sum(IIf([Type]="visa",1,0))

[edwardcga]

Thanks. I follow your suggestion and it works.

ew