I am attempting to do an eCount in Access to return a sum of unique values. I have 1257 records but I know through a physical count, I really only have 315 unique values.
See attached file:
In Column A, I know there are 36 unique Work_IDs - I need an eCount syntax that would provide this.
Then, I need to count the Total number of Work_IDs where the Project Adoption Level only is 1 or 2; or the Assessment Status for the Work_ID is only Closed.
work_id #_Phases_Assessed Assessment Status Project Adoption Level 20545 1 Closed 1 20549 2 Closed 1 20550 1 Closed 1 20551 1 Closed 1 20553 2 Remediation 20560 2 Closed 1 20571 1 Closed 1 20571 2 Remediation 20572 1 Closed 1 20572 3 Remediation 20573 2 Closed 1 20573 2 Remediation 20574 1 Closed 1 20574 1 Remediation 20576 1 Closed 1 20576 1 Remediation 20578 4 Closed 1 20582 3 Remediation 20585 1 Closed 1 20589 1 Closed 1 20592 1 Closed 1 20602 2 Closed 1 20614 1 Closed 1 20633 1 Closed 1 20644 1 Closed 1 20646 1 Closed 1 20647 1 Closed 1 20680 2 Closed 1 20680 1 Remediation 20682 2 Closed 1 20682 1 Remediation 20703 1 Remediation 20711 1 Closed 1 20711 1 Remediation 20712 3 Remediation 20817 1 Remediation 20864 3 Remediation 21157 2 Remediation 21158 2 Remediation 21159 2 Closed 2 21161 2 Closed 2 21164 2 Remediation 21322 1 Remediation 21509 1 Remediation
Can someone assist with this please?
Thanks
Randy