SUM Query with IF and Then Statement

[chineloogbonna]

Good Afternoon,
I am new to Access and was hoping to get some help with a query. I have a form built with a sum button. When button is clicked I want it to count all records when a match is found in the HandledType_fld.

Example: "HandledType_fld" can have Completed, Handled, NoAction etc. I'd want the query to count 5 Completed; 3 Handled and 2 NoAction.

If [HandledType_fld] = "Completed" Then
SELECT SUM(Baseload) FROM Taglines WHERE Baseload = "Baseload C";
End If

Any help you can assist with would be greatly appreciated!

 

[arnelgp]

If you want to show the Count on an unbound textbox in the form, there is no need for a button.
Use the Form's Current event:

Private sub form_current()
On error resume next
Me.txtCompleted=dcount("1", "yourTableName","handledtype_fld='completed'")
Me.txthandked=dcount("1", "yourTableName","handledtype_fld='handled'")
Me.txtNoaction=dcount("1", "yourTableName","handledtype_fld='NoAction'")

End sub

Or in 1 line:

Me.txtStatus=dcount("1", "yourTableName","handledtype_fld='completed'") & " Completed, " & dcount("1", "yourTableName","handledtype_fld='handled'") & " Handled, " & dcount("1", "yourTableName","handledtype_fld='NoAction'") & " No Action"