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)