access 16, amend queries to make count per columns

[akika]

Hi,

How can i amend below query to add more conditions to it as in counts in the output:
Table: tbl_order
columns (ID, Order_status, Order, Sent, Order_Response, Delivery_Status).


SELECT
Count(tbl_order.ID) AS Balance,
Sum(IIf([tbl_order.Order_Status]="Active",1,0)) AS Order_status_Active,
Sum(IIf(tbl_order.[Order_sent]="Yes",1,0)) AS Order_Sent,
Sum(IIf([tbl_order.Order_Response]="Yes",1,0)) AS Order_Response
FROM tbl_order;

---------
Count for the Outputs of query:

Num of Records Order_Status (Get total Count with status = Active) Order_Sent (get total Count with order_status = Active AND order_sent = Yes) Order_Response (get total Count with Order_status = Active, and Order_sent=Yes, and Order_Response = Yes)

[pbaldy]

This type of thing:

Sum(IIf(tbl_order.[Order_sent]="Yes" AND [Order_Status]="Active",1,0)) AS Order_Sent