Good Afternoon,
Background-
I am working on a report that gives a summary of quality samples. We have 2 departments who do quality samples. "Internal Audit" and "PSO Quality". Unfortunately, "Internal audit" will put the same sample number in multiple times which gives me an invalid count.
Need-
I want to be able to report the number of Distinct samples done by "Internal Audit" as well as "PSO Quality".
I have already tried:
Subquery - Not smart enough I suppose
ECount - Again???
Your help would be greatly appreciated!
Thanks,
Adam