Hi everyone,
I have a question regarding a statement and I am not clear how to define this:
I have a query named [Task_qry] and into the query the fields [Department_Responsible] and [Status]
Into the field [Department_Responsible] (droplist field) the data "Quality", "Production", "Maintenance", "Logistic"
Into the field [Status] (droplist field also) the data "Complete" and "Pending"
What I want to get after execute is
Department Complete Pending
Quality 3 5
Production 5 10
Maintenance 1 6
I was thinking something like make the query with this conditions
Field: Responsible_Action
Table: Task_tbl
Total: Group By
Field: Complete: Count(*)
Table:
Total: Expr
Criteria: I don't know how to define this---- WHERE [Task_Query]![Status] = "Complete" (I know this is wrong... but how can I state this)
Field: Pending: Count(*)
Table:
Total: Expr
Criteria: I don't know how to define this---- WHERE [Task_Query]![Status] = "Pending"
I highly appreciate the help or ideas how to do this