Records needs to be count.....

[b.saimsc]

Hi all,

I have created a form, depend upon payment status selection ( drop down have "paid", "not paid" , "insurance") I need separate count. please check the attached image for your reference. Please Help me...................



Thank in Advance

[b.saimsc]

please help me..

[June7]

Try: =Sum(IIf([Payment Status]="Paid",1,0))

[b.saimsc]

Private Sub Text186_Click()
Text186 = Sum(IIf([Payment Status] = "Paid", 1, 0))
End Sub

But getting
Complile error:
Sub or Function not denfined

......... not working

[June7]

I meant for it to be in the ControlSource property of textbox.

[b.saimsc]

not getting result............instead of result it's showing "#Error" in that paid column

[June7]

Works for me. If you want to provide db for analysis, follow instructions at bottom of my post.

[b.saimsc]

You rock..........It's working fine........Thank you so much